| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Past 30 montha
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Past 30 montha
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to Past without Percentage Zero | Excel Discussion (Misc queries) | |||
| Copy and Past | Excel Discussion (Misc queries) | |||
| column help- can I go past IV? | Excel Discussion (Misc queries) | |||
| Past Due - Due Dates | Excel Worksheet Functions | |||
| Past Value automatically | Excel Discussion (Misc queries) | |||
Linear Mode
