| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic update of data in excel charts
How can I set up the excel chart to update as new data is added on a daily
basis? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update of data in excel charts
I assume by added you mean appended to the existing data range.
i.e. Day one A1:A20 Day two A1:A35 etc. Create Dynamic Ranges for your graph data sources. These will expand/contract to fit the source ranges. See Stephen Bullen's site to download a sample workbook that shows you how. http://www.oaltd.co.uk/Excel/Default.htm Scroll down to FunChrt1.zip and download the workbook. Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 12:59:01 -0800, shantz wrote: How can I set up the excel chart to update as new data is added on a daily basis? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update of data in excel charts
Thanks Gord - the link clearly explains how to create dynamic ranges, and I
am able to automatically update my charts. "Gord Dibben" wrote: I assume by added you mean appended to the existing data range. i.e. Day one A1:A20 Day two A1:A35 etc. Create Dynamic Ranges for your graph data sources. These will expand/contract to fit the source ranges. See Stephen Bullen's site to download a sample workbook that shows you how. http://www.oaltd.co.uk/Excel/Default.htm Scroll down to FunChrt1.zip and download the workbook. Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 12:59:01 -0800, shantz wrote: How can I set up the excel chart to update as new data is added on a daily basis? . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update of data in excel charts
Good to hear.
Thanks for the feedback and thanks to Stephen. He saved my butt with this many years ago when I was still working for a living. Gord On Tue, 17 Nov 2009 18:28:02 -0800, shantz wrote: Thanks Gord - the link clearly explains how to create dynamic ranges, and I am able to automatically update my charts. "Gord Dibben" wrote: I assume by added you mean appended to the existing data range. i.e. Day one A1:A20 Day two A1:A35 etc. Create Dynamic Ranges for your graph data sources. These will expand/contract to fit the source ranges. See Stephen Bullen's site to download a sample workbook that shows you how. http://www.oaltd.co.uk/Excel/Default.htm Scroll down to FunChrt1.zip and download the workbook. Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 12:59:01 -0800, shantz wrote: How can I set up the excel chart to update as new data is added on a daily basis? . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update of data in excel charts
I am still working for a living :)
"Gord Dibben" wrote: Good to hear. Thanks for the feedback and thanks to Stephen. He saved my butt with this many years ago when I was still working for a living. Gord On Tue, 17 Nov 2009 18:28:02 -0800, shantz wrote: Thanks Gord - the link clearly explains how to create dynamic ranges, and I am able to automatically update my charts. "Gord Dibben" wrote: I assume by added you mean appended to the existing data range. i.e. Day one A1:A20 Day two A1:A35 etc. Create Dynamic Ranges for your graph data sources. These will expand/contract to fit the source ranges. See Stephen Bullen's site to download a sample workbook that shows you how. http://www.oaltd.co.uk/Excel/Default.htm Scroll down to FunChrt1.zip and download the workbook. Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 12:59:01 -0800, shantz wrote: How can I set up the excel chart to update as new data is added on a daily basis? . . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatic update of data in excel charts
Exactly what I needed.
Thank you and Stephen. wal50 "Gord Dibben" wrote: I assume by added you mean appended to the existing data range. i.e. Day one A1:A20 Day two A1:A35 etc. Create Dynamic Ranges for your graph data sources. These will expand/contract to fit the source ranges. See Stephen Bullen's site to download a sample workbook that shows you how. http://www.oaltd.co.uk/Excel/Default.htm Scroll down to FunChrt1.zip and download the workbook. Gord Dibben MS Excel MVP On Tue, 17 Nov 2009 12:59:01 -0800, shantz wrote: How can I set up the excel chart to update as new data is added on a daily basis? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic Update of Sharepoint Data in Excel | Excel Discussion (Misc queries) | |||
| automatic data update | Excel Discussion (Misc queries) | |||
| Excel 2003 charts will not auto update to new data. Ideas? | Charts and Charting in Excel | |||
| Automatic update of spreadsheet & automatic update between workboo | Excel Worksheet Functions | |||
| Automatic data update | Charts and Charting in Excel | |||
Hybrid Mode
