Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
If you’re still game for a change in chart types,
here’s how it’s done:
Changing Chart Types
This is probably the trickiest thing you can do to
an existing chart. Why? Because many times, the
data you selected, with the original chart type in
mind, isn’t conducive to any other kind of chart.
Or perhaps the formatting you’ve applied will
conflict once the new chart type is applied. Lots
of things can “go wrong,” in that you won’t love
the chart you end up with after changing to a
new type of chart. It’s a relatively safe prospect if
all you’re doing is going from, say, a 2D Column
chart to a 3D Column chart, or if you’re
changing to a Line chart with dots at each data point,
instead of the one you have now with no dots.
Changing from a Column or Bar chart to a Pie?
It may be more trouble than simply making a
new chart, because a Pie chart should only plot
one data series, and your Column, Bar, or Line
chart may have multiple data series in it.
1. Click on the chart to activate it. This is
necessary only if your chart is on a worksheet with
data—if it’s on a Chart Sheet (if you chose to
place it on a new sheet when you created it
or when you chose to move it), the chart is
active whenever that sheet is active.
2. View the Design tab, and click the Change
Chart Type button.
3. In the resulting Change Chart Type dialog
box (shown in Figure 11-31), pick the type of
chart you want from the list on the left, and
then pick the exact chart within that type
from the choices on the right.
4. Click OK to apply the new chart type.
Pick a chart type, any chart type, that’s a good match
for the data you’re plotting in the chart.