Secondary axis

[srpavar]

I am using Office 2007 and used clustered cylinder chart i am trying to use
secondary axis by slecting data series, but i am not able to select the
secondary axis how to do it, same thing i am able to do it in office 2003 for
clustered column chart, can anyone help me

 

[Andy Pope]

Hi,

You can not use the secondary axis with charts that have 3d effect. True in
all versions of XL.

Cheers
Andy

 

[ShaneDevenshire]

Hi,

Switch to a standard Cluster Column, not a Pyrimid, Cone or Cylinder type.

 

[srpavar]

Hi,
Can u give me any other solutions how to use secondary axis in excel 2007.
Thanks in advance.

 

[srpavar]

Hi,


Thanks for the suggetions, other than standard column can i use other types

 

[Andy Pope]

You need to select a chart style that does not have the 3d effect.
Cluster column for example.

Cheers
Andy