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:

Please Login or Register  to view this content.

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!

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

HTH
Ola Sandström

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


--
Don Guillett
SalesAid Software
[email protected]
"madeqx" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>