Multiple charts on 1 page - same static axis?

[#1]

Hi there folks,

Is there any trick to make sure that multiple charts on the same page where I need them all to have the same axis.

I can't just set it manually as the charts update dynamically as per list box selections.

On top of that I'd also want the number to round to the nearest hundred thousand!!

Any ideas??

Thanks!

Stu

[Gysbert_Wassenaar · Accepted solution]

Use variables for the static min and max settings in all the charts. You'll only have to change the values in the variables to have all the charts use the same new values.

[#3]

cool - thanks