Updating excel charts
Be sure you don't use Columns A and B for any other data; otherwise, COUNTA will return an incorrect value.
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
It seems if I could grammatically call the refresh function that should work. I have tried linking the cells to a table that updates correctly but will not update the chart linked to it.
The table, like the normal ranges, will update the values and the chart with the refresh function Button.
You won’t have to depend on others to manipulate or mess up the chart, and you won’t have to do all that extra work either.
You don’t need any Visual Basic skills, but you do need to understand the basic fundamentals of Microsoft Excel charts.
For instance, Excel automatically updates a chart when a change is made to the chart data.
I have a dynamic chart that is linked to an array formula. The data is repopulating correctly in the ranges, (weight vs time).