Forum Discussion
Chart vertical axis values linked with formula
I need to link the maximum and minimum values of the vertical axis as per the formula. How can I do so?
Excel does not have built-in support for dynamic min and max values of a chart axis. It can be done using VBA (in the desktop version of Excel for Windows and Mac). See for example Link chart axis maximum and minimum to cells | Excel