Microsoft Office Tutorials and References
In Depth Information
Create a
COMBINATION CHART
If you show more than two data series in a single
chart, you can change the chart type for one or more
series and create a combination chart. Using different
chart types can make it easier to distinguish different
categories of data shown in the same chart. For
example, you can create a combination chart that
shows the number of homes sold as a line chart and
the average sales price as a column chart.
When you plot two different types of data in the
same chart, the range of values can vary wildly. For
example, the range of values for homes sold might
be between 9 and 15 while the range of values for
the average sales price might be between 760,577
and 936,966. You can plot each of these data series
on a different vertical axis to make it easier for the
user to see values for the associated series. In the
example, you could plot average sales prices on
one vertical axis and number of homes sold on the
other vertical axis.
2
1
Select the data you want to
chart.
2
Click the Insert tab.
3
Select a chart type. Excel charts
your data.
l The Home Sold data series.
l The Average Sales Price data
series.
C REATE A S ECONDARY A XIS
1
3
1
Click a data point in the series
you want to place on a
secondary axis.
1
l The Chart tools become
available.
2 Click the Format tab.
3 Click Format Selection in the
Current Selection group.
l The Format Data Series dialog
box appears.
2
3
4
4
Click Series Options.
5
5
Click Secondary Axis (
changes
to ).
6 Click Close.
l Excel plots the data you chose on
a secondary Axis.
6
150
 
Search JabSto ::




Custom Search