Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
Changing the Chart Options
Any aspect of your chart can be
changed. Anything. You can change to a different
type of chart entirely, you can change the color
of your columns, bars, lines, or pie slices, you can
add titles, you can move and resize the legend,
and you can add labels to your chart to identify
data and values. Figure 11-13 shows a Pie chart
with a chart title and slice labels that indicate the
percentage of the total that each slice represents.
Selected Cells
Slice Labels
Chart Title
Switching Your Chart’s Focus
The focus of your chart is determined by which
data is on the category (the X, or horizontal)
axis. Why? Because this is the most obvious and
first-noticed information in your chart if it’s a
Column or Line chart, two of the most commonly
used chart types. Excel makes it easy to swap the
data that’s currently in your legend for what’s
currently in the category axis, thus changing the
focus of your chart. Still not clear on this? Look
at Figure 11-14, where the chart on the left has
the cities in the category axis and the quarters
in the legend, and the chart on the right that’s
set up in the opposite way—quarters along the
category axis and cities in the legend. Neither
chart is “better” than the other, but depending
on your audience, one of the charts will be more
effective than the other. Salespeople, for example,
who are likely to be competing with other
locations’ sales numbers, will want to see the city
data along the category axis, whereas
accountants or auditors will be more interested in when
the sales were made, and want to see quarterly
data along the horizontal axis.
Figure 11-13
Want a title on your chart? Need to add more
information? It’s all just a few clicks away
in the Chart Tools section of the ribbon.
Figure 11-14
Switch your rows and columns to change
the focus of your chart.
Search JabSto ::

Custom Search