Linked cells in excel not updating
Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? If you want a ready-to-use solution, try Tushar Mehta’s Auto Chart Manager add-in, available as a free download at You can write the entire procedure yourself, but it’s easier and more reliable to let the VB Editor start it for you. There are a few pieces you need to make this technique work. Click on the left hand dropdown at the top of this module, and select Private Sub Worksheet_Change(By Val Target As Range) With Active Sheet. Linking in this context does not mean hyperlinking.(To do that, just right-click on a shape and select the Hyperlink option from the context menu.) Instead, we mean that the shape's text is bound to a worksheet cell, so that when the cell's content changes the text in the shape is updated automatically.You probably arrived at this page because you are a business professional who has to present regularly to management or executives on analysis you have done in Excel.
See how to set up axis-scaling formulas in Calculate Nice Axis Scales in Your Excel Worksheet.
But what if you want the shape's text to be a combination of two or more cells?
Or, perhaps you want the text to be conditional upon an Excel formula.
You can let Excel scale the axes automatically; when the charted values change, Excel updates the scales the way it thinks they fit best. Or you could assign the code to a button in the worksheet. A more elegant approach is to change the relevant axis when one of the cells within B14: C16 changes.
Or you can manually adjust the axis scales; when the charted values change, you must manually readjust the scales. We can use the has appeared automatically atop the module.