|
|
#3
11-06-2021, 06:47 AM
|
||||
|
||||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| keyed sortable table data | ewso | Excel | 5 | 01-07-2017 12:48 AM |
 Auto update excel graph range, ignore data when date reads 00-Month-00
|
SavGDK | Excel | 2 | 06-24-2016 08:05 AM |
|
Plotting a graph to show individual SKU sales over time
|
JumpInTheFire83 | Excel | 1 | 12-07-2015 01:57 PM |
|
Graph occurences over full range of time?
|
pixeldroid | Excel | 1 | 07-13-2015 09:30 AM |
| Update a summary chart when I update a dashboard with dates | cangelis | Excel | 6 | 09-24-2014 08:08 AM |
Windows 10 
Office 2019
Threaded Mode