Forum Discussion
Line chart dynamic scaling of Y-axis
Micro$oft, please, please, pretty please with sugar on top, END the ensh*ttification, and get the Y-axis of a line chart to dyanmically scale with the data range that is being plotted. The range defaults to 0 as the lowest Y-value. The only way to change it, is to manually set the ax range, or use a work-around involving VBA. So... NO! This is crazy!
It should be easy as apple pie for you lot to add an option to dynamically scale the Y-range in the chart, but I guess you are far too busy pushing people onto your crappy AI, which you can really stick some place the sun doesn't shine.
Thank you.
1 Reply
Hi Chef2000, I get why this is frustrating. Excel charts auto-scale in many normal cases, but filtered ranges, visible-only logic, and dynamic setups often need a helper range or automation. A practical workaround is calculating visible min/max values in cells, then using a small VBA macro or Office Script to apply those values to the chart axis.
