Chart auto-resizing problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

baldgeezer - 27 Jul 2005 10:14 GMT

Hi - does anyone know how to stop a chart auto-sizing? I need the chart to
stay the same size. At the moment, depending on what data is graphed, the
y-axis auto-sizes so the chart window becomes bigger.

Reply to this Message

Robert Bruckner [MSFT] - 28 Jul 2005 04:52 GMT

Have you tried opening the chart properties dialog and setting explicit
values for the Y-axis minimum / maximum property?

-- Robert

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi - does anyone know how to stop a chart auto-sizing? I need the chart to
> stay the same size. At the moment, depending on what data is graphed, the
> y-axis auto-sizes so the chart window becomes bigger.

Reply to this Message

baldgeezer - 28 Jul 2005 09:36 GMT

Yes I've set that (e.g. 0 - 100) but depending on the data graphed, the
physical size of the axis enlarges although the scale remains 0-100.

> Have you tried opening the chart properties dialog and setting explicit
> values for the Y-axis minimum / maximum property?
[quoted text clipped - 7 lines]
>> stay the same size. At the moment, depending on what data is graphed, the
>> y-axis auto-sizes so the chart window becomes bigger.

Reply to this Message

Robert Bruckner [MSFT] - 31 Jul 2005 22:12 GMT

The vertical space available for the y-axis also depends on the length/space
needed for the x-axis labels. Unless you ensure the x-axis labels use a
similar amount of space (e.g. by restricting the string length of x-axis
labels) for various data values, the y-axis height may change.

-- Robert

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

> Yes I've set that (e.g. 0 - 100) but depending on the data graphed, the
> physical size of the axis enlarges although the scale remains 0-100.
[quoted text clipped - 11 lines]
>>> the
>>> y-axis auto-sizes so the chart window becomes bigger.

Reply to this Message