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