Charts to automatically include new rows
 

Hi,

Is there an easy way to make a chart automatically include new rows as
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 new
row, i.e. July 2005 with figures, I have to manually update the source
data. Is there an easier way to do this?

Thanks!


--
madeqx
------------------------------------------------------------------------
madeqx's Profile: http://www.excelforum.com/member.php...o&userid=24247
View this thread: http://www.excelforum.com/showthread...hreadid=390538

Create a dynamic named range
insertnamedefinename itin 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


--
Don Guillett
SalesAid Software

"madeqx" wrote in
message ...

Hi,

Is there an easy way to make a chart automatically include new rows as
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 new
row, i.e. July 2005 with figures, I have to manually update the source
data. Is there an easier way to do this?

Thanks!


--
madeqx
------------------------------------------------------------------------
madeqx's Profile:
http://www.excelforum.com/member.php...o&userid=24247
View this thread: http://www.excelforum.com/showthread...hreadid=390538

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

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390538