ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   secondary axis on chart (https://www.excelbanter.com/excel-discussion-misc-queries/81740-secondary-axis-chart.html)

julsnic

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?

David Biddulph

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




All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com