Adding 2nd Y-axis to Excel2003 chart

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

Andy Pope

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
 
Joined
Aug 20, 2012
Messages
7
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top