Using secondary axis

[remppa]

Hi,

(Sorry I first posted this on the general product forums.)

Problem: I can't use multiple axes in Mac Excel 2008 charts. How to create a combination chart with two vertical axes?

I made a simple test chart with my pc laptop that has Office XP. I included two rows: Millions of pieces sold and Percentual growth. On the left there is an axis showing the parts sold, and on the right there's another one displaying the percentages. I opened this file successfully in Mac Office 2008 so it's fully compatible.

But I don't know how to create such a chart in the Mac. Please advise. Thanks!

 

[Carl Witthoft]

Hi,

(Sorry I first posted this on the general product forums.)

Problem: I can't use multiple axes in Mac Excel 2008 charts. How to create a
combination chart with two vertical axes?

I made a simple test chart with my pc laptop that has Office XP. I included
two rows: Millions of pieces sold and Percentual growth. On the left there is
an axis showing the parts sold, and on the right there's another one
displaying the percentages. I opened this file successfully in Mac Office
2008 so it's fully compatible.

But I don't know how to create such a chart in the Mac. Please advise.
Thanks!

The same way as you did under Windows. Go into the various menu items
controlling the chart type, chart options, series options, etc., until
you find the buttons that enable the Secondary Y axis.

 

[remppa]

Thanks for help. I summarize what I learned:

So there is no ready option in the chart type selection for combination charts, or combination charts with 2 axes. For a 2 axes chart, you have to first create a simple chart type, say a column chart and then edit it.

Now, to modify my chart, I point and left-click the data series that I want to put on the secondary axis, then I right-click it to open the menu. Then I click "Format Data Series", select "Axis" and finally "Plot series on secondary axis".

Further, if I want to display one of the data series with line chart instead of a column chart, I first left-click that data series to activate it. Then I can click on the line chart type in the chart types selection, and voila - the data series I selected turns into a curve.

 

[remppa]

Thanks for help. I summarize what I learned:

So there is no ready option in the chart type selection for combination charts, or combination charts with 2 axes. For a 2 axes chart, you have to first create a simple chart type, say a column chart and then edit it.

Now, to modify my chart, I point and left-click the data series that I want to put on the secondary axis, then I right-click it to open the menu. Then I click "Format Data Series", select "Axis" and finally "Plot series on secondary axis".

Further, if I want to display one of the data series with line chart instead of a column chart, I first left-click that data series to activate it. Then I can click on the line chart type in the chart types selection, and voila - the data series I selected turns into a curve, while the other one remains in a column format.