Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 493
Default how to add a secondary axis in excel chart?

Is this possible in `03 version? Don't see "Seconadry Axis" option
available.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default 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.


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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.



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
How Do I Add Multiple Lines On Secondary Axis in Excel Chart? [email protected] Charts and Charting in Excel 1 November 24th 06 05:16 PM
How to place a secondary y axis bar in a bar chart next to two primary y axis bars? Dmitry Charts and Charting in Excel 2 May 4th 06 01:58 AM
Can I put a secondary axis on a 3-D column chart in MS Excel? jk432897 Charts and Charting in Excel 1 April 7th 06 12:57 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
Can I add a secondary (x) axis to the chart in Excel? ecanbay Charts and Charting in Excel 3 June 6th 05 05:34 PM


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

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

About Us

"It's about Microsoft Excel"