Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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: 144
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
 



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 05:02 PM.


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