Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!" |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hardcode a column in a formula | Excel Worksheet Functions | |||
How do I dynamically end a charts X-axis on TODAY() | Charts and Charting in Excel | |||
Dynamically Change Row Count Using SeriesCollection(n).Values | Charts and Charting in Excel | |||
Store values of a dynamically changing cell | Excel Worksheet Functions | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |