Thread: Graphing a dynamic range that automatically picks up the most recent entry.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gimiv gimiv is offline
external usenet poster
  
Posts: 1
Default Graphing a dynamic range that automatically picks up the most recent entry.

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

Reply With QuoteReply With Quote