Problem in plotting data series on secondary axis

  • Thread starter Thread starter Srinivas Reddy
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How To Plot data on secondary value axis in excel chart from vb code 2
chart secondary axis crossing with x axis 1
Assign data series to primary axis 1
secondary axis problem 3
Secondary Axis 9
Secondary Axis 1
X-Axis Appearing in Plot Area 2
Secondary Axis Data Series "Clumping" 3

Back
Top