XY plot auto update with new values

Hi there,

I have data in 2 columns:

t X

1 11
1.4 22
1.8 35
2 42
2.5 57
3 63


Since new values are added each day at the bottom of
each column, I have selected bigger ranges (i.e. A1:A100 eventhough
there is only data in A1:A25)for a XY plot.

However, I noticed that whenever I do that, it's no longer a XY plot,
but rather a line plot:

1 11
2 22
3 35
4 42
5 57
6 63

Is there a way to get a true XY plot with a ranges bigger than the
number of actual data ?

Hi
create a dynamic range as data source for your chart. See the following
sites for instructions:
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards
Frank Kabel
Frankfurt, Germany


Euh wrote:
Hi there,

I have data in 2 columns:

t X

1 11
1.4 22
1.8 35
2 42
2.5 57
3 63


Since new values are added each day at the bottom of
each column, I have selected bigger ranges (i.e. A1:A100 eventhough
there is only data in A1:A25)for a XY plot.

However, I noticed that whenever I do that, it's no longer a XY plot,
but rather a line plot:

1 11
2 22
3 35
4 42
5 57
6 63

Is there a way to get a true XY plot with a ranges bigger than the
number of actual data ?