Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-31-2021, 02:19 AM
dylansmith dylansmith is offline Auto update dashboard graph every time a new value is keyed in Windows 8 Auto update dashboard graph every time a new value is keyed in Office 2013
Optimizer
Auto update dashboard graph every time a new value is keyed in
 
Join Date: Nov 2011
Posts: 129
dylansmith is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-04-2021, 07:15 PM
Guessed's Avatar
Guessed Guessed is offline Auto update dashboard graph every time a new value is keyed in Windows 10 Auto update dashboard graph every time a new value is keyed in Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,794
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

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
Reply With Quote
  #3  
Old 11-06-2021, 06:47 AM
p45cal p45cal is offline Auto update dashboard graph every time a new value is keyed in Windows 10 Auto update dashboard graph every time a new value is keyed in Office 2019
Expert
 
Join Date: Apr 2014
Posts: 537
p45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to beholdp45cal is a splendid one to behold
Default

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.
Attached Files
File Type: xlsm msofficeforums47888.xlsm (22.7 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
keyed sortable table data ewso Excel 5 01-07-2017 12:48 AM
Auto update dashboard graph every time a new value is keyed in Auto update excel graph range, ignore data when date reads 00-Month-00 SavGDK Excel 2 06-24-2016 08:05 AM
Auto update dashboard graph every time a new value is keyed in Plotting a graph to show individual SKU sales over time JumpInTheFire83 Excel 1 12-07-2015 01:57 PM
Auto update dashboard graph every time a new value is keyed in 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft