RE: mix chart types

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!!!
--
John Fallon
Instructional Technology Evangelist for PPT4Teachers.com
Where Instruction and Technology meet for Teachers and the Classroom
http://www.ppt4teachers.com


"Ken Murray" wrote:

> In Powerpoint I need to create a chart with multiple chart types. I want the
> total to show up as a bar and the regions to be data points in the bar. Is
> this possible?
.

Relevant Pages

  • RE: Secondary Axis
    ... I had a scater chart with the following data series A1:A20 the next ... is the vertical axis on the left side of the chart. ... secondary axis, that is, a secondary vertical axis on the right side of the ...
    (microsoft.public.excel.charting)
  • Re: Charts with 2 axis
    ... Does not having this option make the process "unbearably tedious" or that you have to open/close each Format Data Series dialog to change the axis option for each data series? ... Double-clicking on a chart data series and then going to the Axis pane in the Format Data Series dialog and then pressing the Secondary axis radio button appears to work like XL 2004. ...
    (microsoft.public.mac.office.excel)
  • Re: multiple colors on area chart
    ... The recession data is on the secondary axis with a chart type "columns." ...
    (microsoft.public.excel.charting)
  • Re: Chart a time series
    ... How do I chart a time series (a series of dates with a value associated with ... The dates are not evenly spaced, and I would like the axis to be ... I suggest instead that you create a special data series with nothing but zeroes. ... Display that data series, then choose Data Labels.. ...
    (microsoft.public.excel.charting)
  • Re: Chart Help
    ... A combination chart is not needed, and it is not what I described. ... Either you create an XY (Scatter) chart with two data series, ... Format menu to use a secondary axis for the selected series. ...
    (microsoft.public.mac.office.excel)