Charts | Same primary and secondary axis automatically

[hvieira]

Hi,

Is it possible to set the same scale (e.g. min, max) on both the primary and secondary axis of a chart?

If so, does it have to be via a macro?

I know it is possible to do it manually, however when we have dynamic data this is an issue...

Thank you!

Henrique Vieira


P.S.: I'm currently using Excel 2007.

 

[thisoldman]

This may not work exactly as you want, but it's worth a trial.

If you delete the secondary axis, the series plotted on that secondary axis uses the same range as the primary axis. The series still remains on the secondary axis, just the scale should change.

 

[hvieira]

thisoldman,

Your suggestion works just fine!

I guess most times we simply miss the obvious answers!

Thank you for you reply and help!

 

[Klister]

I've been struggling with this as well. I have a very dynamic graph. Not only am I using dynamic values, but depending on the type of data that the user wants to view, the graph type would also change.
I ended up using VBA, and pointing to a cell that calculates for any situation (line or stacked etc.) the max value

Dim lngMaxScale As Long
    lngMaxScale = Sheet22.Range("C93").Value

    ActiveChart.Axes(xlValue, xlPrimary).MinimumScale = 0
    ActiveChart.Axes(xlValue, xlPrimary).MaximumScale = lngMaxScale
    ActiveChart.Axes(xlValue, xlSecondary).MinimumScale = 0
    ActiveChart.Axes(xlValue, xlSecondary).MaximumScale = lngMaxScale