Chart Scale Question

[djdiplomat]

Is it possible to set the maximum vertical axis value on a chart to that of another chart which is set to auto?

For example:

I have a set of two dynamic charts. One is reporting revenue, the other is reporting profit. I want the scale on both charts to be the same but the scale maximum will need to change when different items are selected to accommodate the maximum value.

I want the profit chart scale to match that of the revenue chart (which will be set to auto)

Any ideas?

Thanks

 

[GlennUK]

If you add the revenue series to the profit chart, does the scaling match as required?

( if so, then do that and set the series line color and marker to be None ).

 

[djdiplomat]

If you add the revenue series to the profit chart, does the scaling match as required?

( if so, then do that and set the series line color and marker to be None ).

Great - that will work (why didn't I think of that?!)

Thanks very much!

 

[GlennUK]

Ha ha, my pleasure!