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 - 10 Jun 2006 08:27 GMT
Have a look at this web site that covers your requirement:
http://peltiertech.com/Excel/Charts/Dynamics.html
Rob
> Hi,
>
[quoted text clipped - 4 lines]
> 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.
WaterDog - 11 Jun 2006 19:25 GMT
Thanks, that worked.
> Have a look at this web site that covers your requirement:
> http://peltiertech.com/Excel/Charts/Dynamics.html
[quoted text clipped - 10 lines]
>> automatically updated when I add a new row of data to the table? Thank
>> for any help.