Microsoft Office Tutorials and References
In Depth Information
Creating a Basic Chart
Selecting Chart Data
and Creating the Chart
So now that you know what kind of chart you
need—one that shows comparisons, trends, or
both, most likely—you can begin choosing the
data that will be plotted in the chart. To do so,
follow these steps:
5. Observe the resulting chart, shown in Figure
11-8, overlapping your data.
Chart Tools Section of the
Ribbon Is Now Active
1. Open the worksheet containing the data you
want to chart.
2. Using your mouse and/or keyboard, select
the cells containing the data you want to
plot in the chart. You should include column
and row headings, as shown in Figure 11-7,
because this information will become part
of the chart, populating the category axis
and the legend.
The default location for the chart is rarely where you
want it—it covers the data used to make it.
6. As needed, drag the chart to an unpopulated
section of the worksheet, so your data is not
obscured. Figure 11-9 shows a chart in transit.
Select the headings and numeric data that
you want to use in your chart.
When moving your chart within the same
worksheet, mouse over the border and
keep an eye on your mouse pointer—
when it turns to a four-headed arrow,
you’re ready to drag the chart to a new
3. Click the Insert tab to display that ribbon.
4. Click the button for the type of chart you
want—Column, Line, Pie, Bar, Area, Scatter, or
one of the Other Charts—and make a selection
from the drop-down menu.