Y Axis : Dynamically Hardcode Min/Max Values?
 

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

--
"Trying to make reports so easy... even a monkey could run 'em!"

Y Axis : Dynamically Hardcode Min/Max Values?
 

The technique is outlined here (it requires VBA):

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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RayportingMonkey" wrote in
message ...
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

--
"Trying to make reports so easy... even a monkey could run 'em!"