# Make two or more graphs have the same scale

I have several area graphs in an Excel spreadsheet. I want all of those graphs to have exactly the same scale.

Each of the graphs have a measurement in meters on each of the axes. I want each of the axes to be exactly proportional to each other, so not like this:

But (roughly) like this (the image is squished, this is just a demonstration, I need Excel to do that for me):

Is this possible without either using an image editor, or just manually scaling the graphs "by eye"?

If it's relevant, my Excel version is 2013. Also, don't worry about the graphs being upside down, they're meant to be like that.

I don’t know what you mean by “by eye”.

I constructed a couple of charts that are similar to yours:

Click on the X axis of the bottom chart, right click → Format Axis:

Note the minimum and maximum.  Then bring up the Format Axis of the top chart and set its values to the same as the bottom chart:

Now the graphs have the same scale:

• This doesn't seem to work for area charts, but I never knew about this, and it looks quite cool, so +1. I'll accept it, and be very thankful, if you explain either how to make it work for area charts, or how to style a scatter graph like or very similarly to an area chart. – Bluefire Nov 21 '13 at 16:35
• A couple of questions: (1) Do you guarantee that, in each chart, the X axis points form an arithmetic progression (e.g., 214.4 = 2×107.2, 321.7 = 3×107.2, etc.)? (2) How would you feel about having the X axes labeled something like 0, 100, 200, …, instead of the X coordinates of the data points? – Scott Nov 21 '13 at 19:19