If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? . |
Thread Tools | |
Display Modes | |
|
|