controlling plot area


B

Brad

Excel 2003

I have several charts on a dedicated chart sheet, each with the same number
of bars of graphed data.

I want to adjust the plot area to a particular size within the chart area
for each chart. I have used the "Selection.Height" and the other associated
"selections" with some success, but the plot areas still seem to reset
themselves a bit.

Any ideas on how to fix this would be appreciated and my thanks in advance.

Brad
 
Ad

Advertisements

J

Jon Peltier

The plot areas resize based on the font size, the length of the labels, the
wind speed and direction, and various other uncontrollable factors. I think
there may even be a slight difference if the chart or plot area is selected.

I have a utility, fairly rudimentary and not thoroughly documented, that I
use to line up charts and their plot areas:

http://peltiertech.com/Excel/Zips/AlignChartDimensions.zip

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top