EasterGreen
Board Regular
- Joined
- Sep 7, 2009
- Messages
- 50
I have a waterfall chart in a report that has different departments' data fed in to it and each has significantly different spends.
For larger departments the total "start" and "end" columns are quite tall and force the chart axis to be large numbers.
Any minor bars showing small movements between start and end are hard to interpret.
Is there any way to dynamically change the Y axis minimum from zero to x such that I can set a formula to define the start point?
Image 1 is the automatic axis, Image 2 is where I have manually altered the axis start point.
For larger departments the total "start" and "end" columns are quite tall and force the chart axis to be large numbers.
Any minor bars showing small movements between start and end are hard to interpret.
Is there any way to dynamically change the Y axis minimum from zero to x such that I can set a formula to define the start point?
Image 1 is the automatic axis, Image 2 is where I have manually altered the axis start point.