Y Axis : Dynamically Hardcode Min/Max Values?

[RayportingMonkey]

I have a number of data tables in a summary topsheet. I have added a dynamic
table that uses the indirect function to populate this grid and generate a
graph for only the data our execs want to see.

If I choose the "Auto" feature to assign the Min/Max Value of the Y Axis,
some of the lines in the chart appear too flat... I need to be able to assign
Min/Max Values for the Y-Axis based on my criteria, not Excel's default
selcetions (i.e. the min value should almost never be 0 on these graphs, but
from chart to chart, some are 10 some would be 10,000).

I am using Excel 2003 SP3 in XP.

Thanks for your help!

Regards,
Ray

 

[Jon Peltier]

The technique is outlined here (it requires VBA):

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

Tushar Mehta has a utility on his web site called Auto Chart Manager which
handles this for you (http://tushar-mehta.com).

- Jon