I've search and tried everything I can think of to turn on the secondary
axis. I've even recorded a macro to see what Excel does but no luck.

Set c = Charts.Add
With c
.HasAxis(xlValue, xlSecondary) = True
.Axes(xlValue, xlSecondary).CategoryType = xlAutomatic
End With


I get "Method 'Axes' of objecty '_Chart' failed".

What am I doing wrong?

*** Sent via Developersdex http://www.developersdex.com ***

Sorry folks. I figured it out.

I guess you can't have a secondary axis until you have one or maybe
multiple series in your chart.

I moved the code down after the series were created and voila it works.




*** Sent via Developersdex http://www.developersdex.com ***

You need at least two series, one for the primary axis, the other for the
secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Edward Ulle" wrote in message
...
Sorry folks. I figured it out.

I guess you can't have a secondary axis until you have one or maybe
multiple series in your chart.

I moved the code down after the series were created and voila it works.




*** Sent via Developersdex http://www.developersdex.com ***