#1
|
|||
|
|||
Auto update dashboard graph every time a new value is keyed in
Say Cell A1 = Net Worth and it is updated periodically (sometimes weekly, sometimes monthly).
Instead of manually creating another table to store all past values in A1, is it possible to auto transfer these historical values in A1 to create my bar graph? I want to eliminate the extra step of creating another table if possible. Also like to know if I can plot the % change for every value without first creating the table too. Thank you. |
#2
|
||||
|
||||
As far as I know, the data has to sit somewhere. Changing the value in one cell deletes the previous value in that cell unless the old value has been written somewhere else. The location of the historical data doesn't need to be visible on a sheet - but it does need to exist somewhere.
I would have thought you need two data points for each new value: The applicable date and the value on that date.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
||||
|
||||
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 |