Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default 2 axis in excel 2007

Hi,

I have installed Office 2007 and unable to make graphs with 2 axis (one
on the left and the other on the right) in excel.

Excel 2003 had such graphs templates available.

How do I create 2 axis charts in excel 2007. Any suggestions.

Regards
Sandip.

  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default 2 axis in excel 2007

On the chart, right click the data series to have secondary axis
Select Format Data Series from popup menu
In the Series Options page click the Secondary Axis option button

The right click "trick" is very useful in this, and older version of XL, for
finding context specify items
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
Hi,

I have installed Office 2007 and unable to make graphs with 2 axis (one
on the left and the other on the right) in excel.

Excel 2003 had such graphs templates available.

How do I create 2 axis charts in excel 2007. Any suggestions.

Regards
Sandip.



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
why can I not format a secondary axis in excel x? mackie99 Charts and Charting in Excel 5 April 5th 23 02:47 PM
Double Filtering in Excel 2007 Rebecca New Users to Excel 7 June 14th 06 09:52 PM
I could NOT resize the axis title but excel allows me to resize gr Iwan Setiyono Ko Charts and Charting in Excel 4 June 6th 06 04:46 AM
replace axis text with graphics on excel chart (excel 2003) Mad_Hatter_29 Charts and Charting in Excel 3 December 6th 05 01:42 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


All times are GMT +1. The time now is 04:50 AM.

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

About Us

"It's about Microsoft Excel"