Linked cells in excel not updating

Rated 3.99/5 based on 928 customer reviews

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.

Leave a Reply