If your data is part of a list ( look under data - list - create list ),
then charts will automatically pick up the last entry into the list.
"gimiv" wrote:


I'm looking to create a graph that contains series data from a column on
another sheet (Weekly), but automatically updates the series X/Y axis
(Dates, volume) as new entries are added to the series. Any ideas.

Series in cell AK4 - AK600 on a sheet called Weekly

any ideas?


Thanks
Gimi


--
gimiv
------------------------------------------------------------------------
gimiv's Profile: http://www.excelforum.com/member.php...o&userid=35726
View this thread: http://www.excelforum.com/showthread...hreadid=560012