Sizing plot areas equally?

[wlotto]

How could I size chart's plot areas equally, height and
width? Both charts have different series and categories.
- thanks.

 

[Tushar Mehta]

The easiest non-programmatic solution:

Stack the two charts one on top of the other. For whichever is on top:
double-click each of the Plot Area and the Chart Area. In the
respective dialog box, from the Patterns tab, set the Area to None.

Now, size the two charts to achieve the desired effect / alignment.

Once done, position the charts as desired. For the chart that had the
plot/chart area set to none, reset the two area to the original.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Just this morning I added an add-in to my web site that does this:

http://peltiertech.com/Excel/Charts/chartvba.html#AlignChtDims

I haven't crashed it in some less-than-extensive testing. I'd appreciate
your trying it and letting me know how it works for you.

- Jon

 

[wlotto]

Thanks everybody for help.
Jon, I downloaded your zipped file. Allow me to ask this
less than a beginner question.

What is an add-in? What does it do?

I have never added anything to my original soft as I am
so afraid if anything wrong happens to it. - thanks.