Hi all,
I'm trying to add a secondary axis to chart. When i've recorded the macro and tried to run it it fails on the selection line...
Can anyone expalin how i can do this using vba?
I'm trying to add a secondary axis to chart. When i've recorded the macro and tried to run it it fails on the selection line...
Can anyone expalin how i can do this using vba?
Code:
ActiveChart.HasAxis(xlValue, xlSecondary) = True
ActiveChart.Axes(xlCategory, xlSecondary).Select
ActiveChart.Axes(xlCategory, xlSecondary).MaximumScale = 1
Selection.TickLabels.NumberFormat = "h:mm:ss;@"
Selection.TickLabels.NumberFormat = "[$-409]hh:mm:ss AM/PM;@"