A combination chart uses two or more chart types to emphasize that the chart
contains different kinds of information. To create this kind of overlay
effect, change the chart type for one or more of the data series in the chart.
For most 2-D charts, you can change the chart type of either a data series
or the entire chart. For xy (scatter) and bubble charts, you can change only
the type of the entire chart. For most 3-D charts, changing the chart type
affects the entire chart. For 3-D bar and column charts, you can change a
data series to the cone, cylinder, or pyramid chart type.
Do one of the following:
To change the chart type of the entire chart, click the chart.
To change the chart type of a data series, click the data series.
On the Chart menu, click Chart Type.
On the Standard Types or Custom Types tab, click the chart type you want.
To apply the cone, cylinder, or pyramid chart type to a 3-D bar or column
data series, click Cylinder, Cone, or Pyramid in the Chart type box on the
Standard Types tab, and then select the Apply to selection check box.
If you clear the Apply to selection check box, Microsoft Graph changes the
chart type for the entire chart even if a single data series is selected.
Secondary axis... When the range of values for different data series
varies widely, or when you have mixed types of data, you can plot one or more
data series on a secondary value (y) axis. The scale of the secondary axis
reflects the values for the associated series. The chart in the example above
shows the number of homes sold on the left y-axis and the average price on
the right y-axis.
When the range of values for different data series in a 2-D chart varies
widely, or when you have mixed types of data (such as price and volume), you
can plot one or more data series on a secondary value (y) axis. The scale of
the secondary axis reflects the values for the associated series.
Click the data series you want to plot along a secondary value axis.
On the Format menu, click Selected Data Series, and then click the Axis tab.
Click Secondary axis.
Hope this info helps!!!
