Chart: Include Constant Lines values in Y-Axis Auto Range?
Posted: Mon Oct 30, 2017 6:18 pm
Hi,
I've noticed that when calculating the Y-Axis range on a line chart any Constant Lines are not included. This may mean that the Constant Lines are not displayed (depending on the data to be displayed).
Q: Is it possible to ensure that any Constant Lines are always displayed?
E.g. the left-hand chart auto-ranges the data but the Constant Line is off the top; value = 55. The chart on the right is nearer to how I'd like to see it.
I have managed to almost do it in event code (see the right-hand chart) but this then doesn't include the built-in clever auto-ranging logic normally used (e.g. to show all the marker values in the right-hand chart).
Thanks,
Chris
I've noticed that when calculating the Y-Axis range on a line chart any Constant Lines are not included. This may mean that the Constant Lines are not displayed (depending on the data to be displayed).
Q: Is it possible to ensure that any Constant Lines are always displayed?
E.g. the left-hand chart auto-ranges the data but the Constant Line is off the top; value = 55. The chart on the right is nearer to how I'd like to see it.
I have managed to almost do it in event code (see the right-hand chart) but this then doesn't include the built-in clever auto-ranging logic normally used (e.g. to show all the marker values in the right-hand chart).
Thanks,
Chris