Dynamic Scaling for Charts

[Barb Reinhardt]

We have some "canned" templates that include charts. In some cases, when
real data is entered, the scaling for the charts isn't what I would consider
optimum. For example:

All of the data is between 0.9 and 1.1, but the scale of the chart is 0 to
1.2. Any suggestions.

Thanks in advance,
Barb Reinhardt

 

[Tushar Mehta]

We have some "canned" templates that include charts. In some cases, when
real data is entered, the scaling for the charts isn't what I would consider
optimum. For example:

All of the data is between 0.9 and 1.1, but the scale of the chart is 0 to
1.2. Any suggestions.

Thanks in advance,
Barb Reinhardt

Not sure what you expect, Barb.

Adjust the min./max. values by hand.

Use an automated solution a la
AutoChart Manager
http://www.tushar-mehta.com/excel/software/autochart/index.html

The basic code is pretty straightforward.

With ActiveChart.Axes(xlValue)
.MinimumScale = -1
.MaximumScale = 2
End With

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions