# Keep Graphs in Proportion

#### iambinary

##### New Member
Hi, how do you keep graphs in proportion after you create them?

So after some edits, let's say the x axis has a max range of 45 and the y axis has a max range of 25, but the graph looks funny...

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### XLXRider

##### Board Regular
For each axis, place your cursor on that axis and right click. Choose the following:

Format Axis.
Scale.

This should do it for you. Experiment with it a little, you'll get the hang of it in no time.

Regards,
XLXRider

##### Well-known Member
Welcome to the board, iambinary.

What is it that "looks funny"? Besides me.

#### iambinary

##### New Member
Oh the max range (number on axis) should stay the same. The actual graph (the outside box; the actual box) is what I'm trying to scale in correct proportion. That the graph is out-of-proportion is what makes it look funny.

##### Well-known Member
You can resize both the outside box (Chart Area) and the inside box (Plot Area) by clicking on them and then grabbing (click & hold) one of the corners. Is that what you're looking for?

#### iambinary

##### New Member
"Chart Area... (click & hold) one of the corners." - yes... now how do I make it so all sides are proportional? the computer does can do it much more accurately than most humans can, but it doesn't scale automatically, so I'm trying to find the option to "Keep Graph in Proportion."

#### iambinary

##### New Member
for "but it doesn't scale automatically," 'it' is referring to the chart area.

#### iambinary

##### New Member
so im assuming excel doesn't have that functionality, which i would be very surprise at since excel does a lot that i don't know about.

anyone know what is the real answer?

Replies
1
Views
159
Replies
3
Views
183
Replies
3
Views
338
Replies
4
Views
260
Replies
0
Views
273

1,196,014
Messages
6,012,860
Members
441,737
Latest member
bijayche

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back