Automatically add new data to charts

[WaterDog]

Hi,

I have a data table containing a time series of values that I also show on a
chart. I add data by adding a new row to the bottom of the data columns. I
then have to edit the data series on the chart to incorporate the new row
into data range so that it shows on the chart. Is there a way to specify
the data range on the chart so that the range is automatically updated when
I add a new row of data to the table? Thank for any help.

 

[Rob]

Have a look at this web site that covers your requirement:
http://peltiertech.com/Excel/Charts/Dynamics.html

Rob

 

[WaterDog]

Thanks, that worked.

Have a look at this web site that covers your requirement:
http://peltiertech.com/Excel/Charts/Dynamics.html

Rob