JaredSorensen
Board Regular
- Joined
- Aug 23, 2007
- Messages
- 160
I want to create a dynamic graph that not only uses a dynamic max value for the Y-axis, but also a dynamic min value that is NOT ALWAYS zero.
Imagine a graph that displays sales for last 5 days. If the max was $24,578 and the min was $15,697, then I'd want the chart to show a lower bound of $15,000 and an upper bound of $25,000. But if the next week the max was $30,209 and the min was $27,810, then I'd want chart lines from about $27,000 to $31,000. The problem is that if I have the "Auto minimum" checked on the Y-axis, then it always gives me a lower bound of 0--all of which empty space I would prefer to eliminate.
The solution may have something to do with the Format Axis > "Category (X) axis Crosses at: " but I have been unsuccessful even as I tried every combination. One graph I have seen from a colleague, that successfully does what I want to replicate, has the "Auto" column checkmarked for both "Minimum" and "Category (X) axis crosses at:" but the trick is that it displays the same (non-zero) value in the "Minimum" textbox and "Category (X) crosses at:" textbox--and that value changes if the minimum value in the graphing series changes.
Any help would be very welcome! Thanks.
Jared
Imagine a graph that displays sales for last 5 days. If the max was $24,578 and the min was $15,697, then I'd want the chart to show a lower bound of $15,000 and an upper bound of $25,000. But if the next week the max was $30,209 and the min was $27,810, then I'd want chart lines from about $27,000 to $31,000. The problem is that if I have the "Auto minimum" checked on the Y-axis, then it always gives me a lower bound of 0--all of which empty space I would prefer to eliminate.
The solution may have something to do with the Format Axis > "Category (X) axis Crosses at: " but I have been unsuccessful even as I tried every combination. One graph I have seen from a colleague, that successfully does what I want to replicate, has the "Auto" column checkmarked for both "Minimum" and "Category (X) axis crosses at:" but the trick is that it displays the same (non-zero) value in the "Minimum" textbox and "Category (X) crosses at:" textbox--and that value changes if the minimum value in the graphing series changes.
Any help would be very welcome! Thanks.
Jared