Microsoft Office Tutorials and References
In Depth Information
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.
Select the data you want to
Click the Insert tab.
Select a chart type. Excel charts
l The Home Sold data series.
l The Average Sales Price data
C REATE A S ECONDARY A XIS
Click a data point in the series
you want to place on a
l The Chart tools become
2 Click the Format tab.
3 Click Format Selection in the
Current Selection group.
l The Format Data Series dialog
Click Series Options.
Click Secondary Axis (
6 Click Close.
l Excel plots the data you chose on
a secondary Axis.