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

Anon wrote:

> 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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info