Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
julsnic
 
Posts: n/a
Default secondary axis on chart

I am trying to do a chart with a secondary axis. I am using excel 2000 and I
can't find the secondary axis. I see under the axes tab only a primary
axis...any suggestions?
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default secondary axis on chart

"julsnic" wrote in message
...
I am trying to do a chart with a secondary axis. I am using excel 2000 and
I
can't find the secondary axis. I see under the axes tab only a primary
axis...any suggestions?


"Format data series" for the series which you wish to use the secondary
axis, go to the axis tab, select secondary axis. [You will, of course, need
at least two series on the graph to allow a secondary axis; if you've only
got one series you can use a dummy as a second one.]
--
David Biddulph


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Secondary Axis chart McInnes Charts and Charting in Excel 1 September 16th 05 08:17 PM
XY scatter and Bar chart - secondary axis misaligned philcud Charts and Charting in Excel 3 August 8th 05 09:00 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
How do I set permanent secondary axis in PivotTable chart? Microlong Charts and Charting in Excel 3 January 8th 05 03:54 AM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"