Automatic update of data in excel charts

  • Thread starter Thread starter shantz
  • Start date Start date
S

shantz

How can I set up the excel chart to update as new data is added on a daily
basis?
 
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
 
Thanks Gord - the link clearly explains how to create dynamic ranges, and I
am able to automatically update my 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
 
I am still working for a living :)

Gord Dibben said:
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



.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up a chart that auto updates as new info is added? 1
I can't figure out how to hold chart references firm when inserting data 2
Can't drag new data to chart in 2007. 1
Automatically shift chart data range 4
Dynamic expanding chart 5
Only Include Last Four Entries in a Chart 1
Some chart types cannot be combined... 1
Chart Update 2

Back
Top