Problem in plotting data series on secondary axis

S

Srinivas Reddy

Hi Everybody,

In my previous request, I asked how to plot data series on Excel
secondary axis from VB and I got the reply from Jon
as follows:
ActiveChart.SeriesCollection(2).AxisGroup = xlSecondary

It is working fine in one form and not some other form, Saying Can't set
the Secondary axis property.

can you pls help me in this regard why this is happening.

Thanks & Regards,
Srinivas

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
G

Greg Koppel

Hello Srinivas,

I think there are certain chart types that don't allow a secondary axis.
Alternately, you may need to use a different property from AxisGroup. Can
you make the change manually? If so, record as a macro to see the proper
code.

HTH, Greg
 
Top