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