Charts to automatically include new rows

[madeqx]

Hi,

Is there an easy way to make a chart automatically include new rows a
they are entered?

I currently have a spreadsheet with three columns: A, B and C.
Column A contains dates (i.e. the period, ex: June 2005)
Column B and C contains figures for the period.

Like so:


Code
-------------------

A B C
March 2005 145 120
June 2005 99 102

-------------------


I have a column-chart displays these figures. But each time I add a ne
row, i.e. July 2005 with figures, I have to manually update the sourc
data. Is there an easier way to do this?

Thanks

 

[Don Guillett]

Create a dynamic named range
insert>name>define>name it>in the refers to box use an offset formula
=offset($a$2,0,0,counta(a:a),1)
then refer to that name in your series
=yourworkbook.xls!yournamedrange

 

[olasa]

Go down to Dynamic Charts:
http://peltiertech.com/Excel/Charts/ChartIndex.html

HTH
Ola Sandströ