Adding 2nd Y-axis to Excel2003 chart

  • Thread starter Thread starter Anon
  • Start date Start date
A

Anon

I am making a simple line chart with two types of column
data. I want to represent them with separate Y-axes.

However, when I select the two columns of data and go
through the Chart wizard the secondary Y-axis option is
inaccessible. Excel 2003 help is no help as it tells me
to go to the Format Menu, click Selected Data Series then
click the Axis tab, but there is no such option under my
format menu.

How do I select the secondary Y-axis option?
 
Hi,

The chart wizard does not give you the option to place the selected data
on 2 axes. You will have to do it once the chart is created.
Select the series that is to be displayed on the secondary axis, CTRL+1
to display the format dialog. Here you can select the secondary axis.

Cheers
Andy
 
You can create three or more Y axes in Excel using EZplot or Multy_Y from OfficeExpander.com
There is a demo version to try.
Cheers.
 
Back
Top