Chart excel

[Stephen Rammer]

Hi,

I am trying to draw a line chart depicting a series of
data. Each week I add a new set of data to the timeseries.
Is there a "smart" way to have this linechart always
include the last dataseries automaticly, so I don't have
to change the range in the chart every week?

Appreciate any help, thanks Stephen

 

[Frank Kabel]

Hi
have a look at
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html

for instructions how to create dynamic charts using defined names