The attached contains the very basics of a way to do it.
Changing the value of cell A1 will update the chart with a timestamp of when you do it.
How?
Unhide Sheet2
See the vba code of Sheet1
Instead of a plain chart, you could have a pivot chart based on the data in sheet2 and have a column in the pivot showing % change. Then you'd need an extra line of code to refresh the pivot.
|