Secondary axis

  • Thread starter Thread starter Rita
  • Start date Start date
R

Rita

one more chart question...

I want to show two axis by enabling them on the chart:
me.chart.HasAxis(xlValue, xlPrimary) = True
me.chart.HasAxis(xlValue, xlSecondary) = True

The primary works - but somehow I cant set the secondary,
so when I later want to specify the axis it fails:
With me.chart.Axes(xlValue, xlSecondary)
.MinimumScale = 0
.MaximumScale = 30
.HasMajorGridlines = True
End With

Strange is it that if I set the primary to false, then I
cant set the scale etc. on that - so I do control the
presence of that axis. That is not the case for the
secondary - when checking, the secondary HasAxis is still
false despite me setting it to true... what is wrong??!!
 
Back
Top