Secondary Y Axis in Excel 2000

  • Thread starter Thread starter Fred
  • Start date Start date
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
 
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
 
Back
Top