![]() |
how to add a secondary axis in excel chart?
Is this possible in `03 version? Don't see "Seconadry Axis" option
available. |
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. |
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