Past 30 montha

[NotGood@All]

I have many entries of data in an Excel spreadsheet. I add to it every day
and would like to create a chart. Is there a way that my chart can update
every time I add a new entry?

Thank You

 

[Andy Pope]

Hi,

You can create a named range, see here for more details
http://peltiertech.com/Excel/Charts/Dynamics.html

Or you could make your range a List, Table in xl2007. Charts based on these
auto expand.

Cheers
Andy