Graphing a dynamic range that automatically picks up the most recent entry.

[gimiv]

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

 

[Guest]

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]

I have the range working, but the cells in which data has not been
entered into yet has the formula =IF(ISERROR(B52/AE52),"",B52/AE52) in
it because is it autmtically calculating weekly percentages based on
the input of the daily percentages in the "Daily" worksheet. So, the
real problem is creating the dynimic range, but not have the range read
cells without values (but possible has formulas).

Thanks,

Gimi