ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how to add a secondary axis in excel chart? (https://www.excelbanter.com/charts-charting-excel/183265-how-add-secondary-axis-excel-chart.html)

ALEX

how to add a secondary axis in excel chart?
 
Is this possible in `03 version? Don't see "Seconadry Axis" option
available.

Andy Pope

how to add a secondary axis in excel chart?
 
Hi,

You need a chart with 2 series. Double click the series and on the axis tab
select Secondary axis.
Not available for any 3d chart styles.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Alex" wrote in message
...
Is this possible in `03 version? Don't see "Seconadry Axis" option
available.



David Biddulph[_2_]

how to add a secondary axis in excel chart?
 
You'll need to have at least 2 data series in your chart.
Select a series, format axis, and at that stage the secondary option should
be available. Initially it will give you a secondary Y-axis, but
subsequently you can change to have a secondary X-axis instead of, or as
well as, the secondary Y-axis.
--
David Biddulph

"Alex" wrote in message
...
Is this possible in `03 version? Don't see "Seconadry Axis" option
available.





All times are GMT +1. The time now is 02:03 AM.

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