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
options.
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.
2
1
Click and drag to select the
worksheet data you want to
chart.
Include row and column
headings.
3
4
2
Click the Insert tab.
1
3
Click a chart type in the Charts
group.
4
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
available.
5 Click the Design tab.
6 Click here and select a chart style.
Excel applies the style to your
chart.
7 Click Quick Layout in the Chart
Layouts group.
8 Click to select a chart layout.
l Excel applies the layout to your
chart.
5
7
6
8
134
 
Search JabSto ::




Custom Search