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 defa...
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.