Automatic updating

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!

Only a pivot chart would need to be updated manually with the refresh button. If you make a normal chart (not pivot), it will update automatically. Sometimes this is tricky, but if you define a named data range with the array of values from your pivot table, it should then allow you to create a normal chart.

Originally Posted by psumvp

Only a pivot chart would need to be updated manually with the refresh button. If you make a normal chart (not pivot), it will update automatically. Sometimes this is tricky, but if you define a named data range with the array of values from your pivot table, it should then allow you to create a normal chart.

ok then, didnt know that. Thanks for the info