Plot area of embedded charts unexplainably shrinks in Excel 2003 S

R

Rudy

I am working on a large spreadsheet full of numerical data. It contains
several dozen bar and line graphs embedded across several worksheets. I have
a decent understanding of Excel and Excel graphs but do not use VBA.

The problem I have with Excel is that it sometimes – and unpredictably –
(vertically) shrinks the plot areas of the embedded graphs. This can happen
between opening the document and printing it. Other times, the plot area
would shrink if I click on the plot area with my mouse, and then click off on
to a cell in the same worksheet. The chart area remains the same size, but
the plot area gets smaller and smaller until I can barely see it. I doubt
that this is due to actions related to resizing columns because I have
checked the options under Format Chart Area:properties:Move and Size with
Cells. I have also turned off the Format Axis:Font:Autoscale option.

Is there any way that I can make these Excel charts stay *completely
static*? I am tired of having to manually resize the plot area every time
this “bug†happens. I would like to avoid using VBA, but am willing to
decide otherwise if necessary. This problem has been plaguing me for weeks
so your help would be much appreciated.

Thanks!
Rudy
 

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