Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 28
Default I cannot make charts with two Y axes anymore

Now that I have Excel 2007, I cannot find the same template as I had
in the previous versions of Excel. I must be missing something.
Lines on 2 axes used to be included on the Custom Types menu, but I
cannot find it anywhere on the 2007 chart menu.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default I cannot make charts with two Y axes anymore

Hi,

Combination charts are not offered as default chart types in xl2007, which
is good.
You will need to format the chart your self. Create the chart as a 2 series
line chart and then select the series you want displayed on the secondary
axis.
Once selected use the Format dialog to select Series Options and change Plot
Series On to Secondary axis.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"jimbo" wrote in message
ps.com...
Now that I have Excel 2007, I cannot find the same template as I had
in the previous versions of Excel. I must be missing something.
Lines on 2 axes used to be included on the Custom Types menu, but I
cannot find it anywhere on the 2007 chart menu.


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
Axes in Charts margie Charts and Charting in Excel 5 March 4th 07 12:32 PM
dual axes charts, 2 questions.... chasida Charts and Charting in Excel 7 January 10th 07 01:08 PM
charts plotted with data on two axes anaoro Excel Discussion (Misc queries) 1 September 4th 06 06:33 PM
Radar charts with independent axes Tom D Charts and Charting in Excel 1 August 21st 06 09:15 AM
Setting axes for 3-dimensional charts owc Charts and Charting in Excel 0 March 17th 06 07:20 PM


All times are GMT +1. The time now is 09:21 AM.

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"