Generating Graph with new data every time its used

[Jimuniguy]

Hello,

Say i have a collection of cells, A1:A30 which i want to make a simple line graph from. Simple. But then each day I add some new cells to the list, it could be any number of cells.

E.g Monday I add 5 cells, A1:A35, or wenesday I add another 15 which makes it A1:A50

How do i make the graph automatically redraw itself with the new data without me having to drag and select the area

Jim

 

[PHV]

Have you tried to use a dynamic named range ?
Take a look in the FAQ area if you don't see what I mean.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Jimuniguy]

Sorry i am unable to find it, which FAQ is it?>

Jim