Thread: Secondary axis
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Secondary axis

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