Past 30 montha

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NotGood@All - 22 May 2008 01:00 GMT

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

Signature

NotGood@All

Reply to this Message

Andy Pope - 22 May 2008 09:23 GMT

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

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>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

Reply to this Message