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

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"srpavar" wrote in message
...
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

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

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"srpavar" wrote in message
...
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

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

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"srpavar" wrote in message
...
Hi,
Can u give me any other solutions how to use secondary axis in excel 2007.
Thanks in advance.

"Andy Pope" wrote:

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"srpavar" wrote in message
...
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

Hi,

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

--
Thanks,
Shane Devenshire


"srpavar" wrote:

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

Hi,


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

"ShaneDevenshire" wrote:

Hi,

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

--
Thanks,
Shane Devenshire


"srpavar" wrote:

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