Secondary Y Axis in Excel 2000

F

Fred

I have not figured out how to select the data for the
secondary axis in a line chart in Excel 2000. The help
menu states "On the Format menu, click Selected Data
Series, and then click the Axis tab". Selected Data Series
does not appear in my Format menu. I could do it easy in
97, but 2000 is not like Excel 97.

I have three primary Y axis sets and two secondary Y axis
sets. They all share a common X set of values Such as:

X Primary Y --------- Secondary Y
1 2.3 2.3005 2.3007 0.0005 0.0007
2 2.4 2.4006 2.4008 0.0006 0.0008
 
T

Tushar Mehta

Plot all five series. Then, on the chart, select the first series you
want on the secondary axis. Now, the format menu will have the
'Selected data series...' item. Alternatively, double-click the series
you want to move to the secondary axis, or right-click on the series
and select 'Formnat Data Series...'

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Similar Threads

Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Coordinate secondary y axis to primary y axis 2
Graphs: 2 Lines on secondary Y-axis? 1
Using the full width of an Excel chart with two Y-axes 2
Chart - Secondary Y-axis with different values/scale 2
Additional secondary axis scales 0
Primary X axis to Secondary X axis 1

Top