Resizing Charts to fit the number of records

S

Stephen Price

Hi,

I'm having problems, using Access 97, trying to resize a
chart on a report at runtime.

The chart is a bar graph which can have a varying amount
of categories on the x-axis. Due to this, I need to be
able to change the height of the chart without it altering
the proportions of the grpah.

If I have the 'Sizemode' property set to 'Clip' then it
will only show the same size as the graph window in MS
Graph. If I set it to 'Stretch' then it stretches the
graph out of proportion.

The chart is placed in the report footer and in design
view the height is quite small.

Has anyone else encountered a similar problem and no a
resolution? Or is my explanation a bit hard to understand?

Grateful for any help.

Thanks
 
Top