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
Bookmarks