View Single Post
  #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.