Is there any (relatively simple) way to make a graph automatically update after the contents of the table its getting its data from updates?
e.g.
Say the info is summing up hours worked, and initially the graph shows for one person 10 hrs. But then they work 2 more and the table updates to show this, how would the graph update.
I know how to do it if they click like a "refresh" button which makes a macro redraw it. Is there some kind of macro code or something that can make it update whenever something is changed?
Sorry if that was a bit confusing.
Thanks in advance!![]()
Bookmarks