ExcelBanter - Past 30 montha

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Past 30 montha (https://www.excelbanter.com/charts-charting-excel/188452-past-30-montha.html)

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
--
NotGood@All

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"NotGood@All" wrote in message
...
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
--
NotGood@All