2

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:

enter image description here

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

enter image description here

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.

1

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

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

graphs with different scales

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

                                "Format Axis" properties dialog box for chart with wider range

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:

                                "Format Axis" properties dialog box for chart with smaller range

Now the graphs have the same scale:

graphs with same scale

2
  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.