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!

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

"Srinivas Reddy" wrote in message
...
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!