Adjust Chart Scale in Rpt with VBA

[Guest]

Hi,

I've been working on creating a lot of chart reports (mostly line charts)
and my Y axis is never accurate. For example, if the line's data goes from a
min of 90 to a max of 140, the Y scale almost has zero as the min and the max
will be something like 160 with a major unit of say 20.

Since each line chart will be different, does anyone know of the code
necessary to read the min/max of the series and then adjust the scaling
accordingly?

Thank you.

kohai

 

[Kevin K. Sullivan]

The following component of the Y-axis can be set automatically or manually.
Minimum
Maximum
Major Unit
Minor Unit
Category (x) axis crosses at:

It sounds like the minimum is currently set manually at 0 but the others
are automatic. Can you open the graph in design mode and switch minimum
to Automatic as well? Or is everything now Automatic, but you're still
not getting the results you want? I usually have a mix of auto and
manual settings based on what auto is good at guessing.

Kevin

 

[Guest]

Kevin,

Thank you for the reply. I know these options are programmable, I am trying
to get the proper syntax to make these changes for the charts in my report.

Thanks.

kohai