Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
Tip
If your change in chart types creates
problems in terms of new or changed
elements in your chart, you can add or
remove the legend (use the Layout tab’s
Legend button), add or remove data
labels (also on the Layout tab), and
tweak things like gridlines, titles, and
the colors of your chart, as needed. If the
chart type you’ve chosen has elements
the previous type did not—such as
gridlines, which would not have been present
in a Pie chart—you can format these new
items to match the current formatting,
which is preserved through the process
of changing chart types.
Figure 11-32
Work with the Select Data Source dialog box to reset
your chart’s data to include additional cells, fewer
cells, or an entirely new range of cells.
Be Sure to Update Your Legend
The Legend Entries and Axis Labels sections
of the Select Data Source dialog box allow
you to make sure your new/changed
selection is properly reflected in the legend and
within the chart’s axes. Use the Add, Edit,
and Remove buttons to update the legend,
and click the Edit button to tweak the
contents of the relevant axis (this option may
vary depending on the type of chart you’re
now using).
Adding/Removing Data
to/from a Chart
If it turns out that your new chart type
would be better served by more or less data
being included, you can reset the chart
data by using the Select Data button on the
Design tab. Click this button and revisit
your worksheet, as shown in Figure 11-32.
Move the dialog box aside (or shrink it) and
drag through the cells you want to now
include in your chart. You can use the Ctrl
key as you click or drag through cells to add
to the existing selection, or start from scratch
by dragging a new selection that replaces
the existing one.
 
Search JabSto ::




Custom Search