2 axis in excel 2007

[sanshah01]

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.

 

[Bernard Liengme]

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