How to update the Chart automatically?

[vickyho1008]

I have a spreadsheet with lots of financial indices, for each of th
indices, I have a chart displaying their performance. These indice
will be updated everyday or everyweek. How can I make the chart to b
updated by itself once a new performance is entered on a new cell
rather than go to Source data and drag the cell down

 

[Debra Dalgleish]

Jon Peltier has instructions for creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html

 

[Andy Pope]

Hi,

Have a look at these examples of dynamic charts.

http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Cheers
Andy
--

 

[Ed Ferrero]

Hi All,

Got tired of having to type all those COUNTA and OFFSET formulas, so have
built a little utility that creates dynamic ranges by point-and-click.

Get it at http://edferrero.m6.net/vba.html

Ed Ferrero