Aligning Axes of Multiple Charts and Rendering All of Them the Same Dimensions

**snl330** · 11-05-2013, 10:19 AM

Hello everyone!

I've got a (mostly) simple inquiry. I want all of the chart axes of all of all of the following charts (their plot areas) to have exactly the same dimensions so that I can align them up perfectly to one another. I've attached a photo of what I've got so far after playing around with the alignment tools and manually dragging the dimensions of each graph:

Screen Shot 2013-11-05 at 8.56.13 AM.png

(Note that the units on each graph are not the same. I don't know it this affects anything or not.)

The axes are very closely aligned; however, perfect alignment is preferred. Is it possible to tell Excel to set the dimensions uniformly among all plot areas of all charts so that I can align them all up perfectly? I selected the plot area of one of the graphs (second to the left) in the attached photo, and the little gold help tag displaying the plot area's dimensions (height and width) is displayed in the upper left corner of the selected plot area. Is it possible to enter the dimensions displayed in that tag in another formatting section of Excel, such as typing them into a box and applying it to all plot areas (similar to selecting all of the charts and applying a uniform size to all of them in the formatting menu)? Is it possible to change the dimensions without using Macro? If I need to use Macro I do not know how to compile it. I can run it however if a code is supplied to me!

Thank you all, it is much appreciated!! Cheers!

-Sam

**arlu1201** · 11-07-2013, 06:14 AM

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

**snl330** · 11-07-2013, 08:25 PM

Sure, arlu1201. (Thanks for the heads up, I'm new at this.)

I found a workaround for the moment where I simply

1) remove the fills of the chart area AND plot area (so the cells behind the chart become visible), then I

2) implement a border on the cells closest to the edge of the plot area (which is one of the axes of the graph), then

3) zoom in to ~250-350 % and

4) manually drag the edge of the plot area to lie directly on the border of the cell (the black line).

Here is a picture:

Screen Shot 2013-11-07 at 7.22.27 PM.png

Just in case anyone else has any other ideas, I will remove the solved tag.

Sam