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?

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?

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?

.

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?

.

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?

.


.

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?

.