Forum Discussion
Chart Vertical Axis based on formula
On stock OHLC or any other chart in MS Excel, how can we set the vertical axis value to be based on the formula?
You mean the maximum/minimum scale of the axes? As far as I know you cannot have a formula that calculates it. You can however add a (hidden) series to the chart with just the minimum and maximum value you want it to use for the axes scale(s).