Microsoft Office Tutorials and References
In Depth Information
CREATE A CHART
that has visual appeal
With Excel 2007, you can create charts with dramatic
visual appeal quickly and easily. Simply select the
data you want to chart and then choose a chart type
from the Insert tab’s Chart group. Excel provides
several chart types from which to choose, including
column, line, pie, bar, area, and scatter charts. In
addition, each chart type has a number of subtype
After you create your chart, Excel makes Chart tools
available to you through the Design, Layout, and
Format contextual tabs. Using the Chart tools, you
can choose a chart style and layout. You can change
the color scheme of your chart with chart styles and
use layouts to add a chart title, axis labels, a legend,
or a data table to your chart. A chart title summarizes
chart content; axis labels explain each axis; a legend
explains the colors used to represent data; and a data
table displays the data presented in the chart. Chart
tools make changing row data to column data, or vice
versa, as simple as clicking a button.
Click and drag to select the
worksheet data you want to
Include row and column
Click the Insert tab.
Click a chart type in the Charts
Click a chart subtype.
Excel creates a chart based on
the data you selected.
l Row data.
l Column data.
l The Chart tools become
5 Click the Design tab.
6 Click here and select a chart style.
Excel applies the style to your
7 Click Quick Layout in the Chart
8 Click to select a chart layout.
l Excel applies the layout to your