same scale on both axes AUTOMATICALY

[arnbormans]

I'd like to have my graph with axes on a same scale. Due to the varying
data I cannot adjust the scale each time. So, does anyone knows how to
get those automaticaly on the same scale? Of course the axe with the
biggest numbers is determinative and the other will follow. Which of
the axes gets the biggest numbers, can also vary...

All this is because I'm working with geographical data...

Thank you
Arn

 

[Frank Kabel]

Hi

as Excel does not support this out of the box maybe the follwoing will
help you:
1. You can link the axes scale to cells on your worksheet. For an
explanation how to do this see
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

2. In both linked cells on your worksheet you can use the MAX function
to ensure the same scales as well as the highest number (maybe you
should round the result of the MAX function).

HTH
Frank