no button clicking, but updates automatically when the worksheet recalculates Does not require user interaction – i.e.Updates automatically whenever data changes.If you’re not familiar with VBA, don’t worry, I’ll talk you through it step-by-step. Hopefully, by the end of this post, you too can share in the automatic cell linked bliss I now experience. Link that formula to a cell and suddenly it is possible to set the chart axis based on a cell value. Below you’ll find the result of that tinkering a formula which exists on the worksheet to control the min and max values of a chart axis. I turned to my old friend VBA, and started to tinker. I decided to build a more dynamic solution. There are various chart objects we can link to worksheet cells source data, chart titles and data labels can all be linked to cells, but the chart axis is set by hardcoding a number into the Format Axis options window. It only takes a few seconds, but all that time starts to add up. It’s such a tedious task, and I know I’ll be doing it again at a future point. “ Not again…” I think to myself every time I change the minimum and maximum values of a chart axis.
