How do I automatically update a graph after adding a data point

I have a weekly graph showing orders per week. The data of this graph is
updated weekly. Today to update the graph I need to select the graph, go to
source data and add one more point. Can I have this done automatically?
Thanks.

This should help you.
http://www.peltiertech.com/Excel/Cha...tml#DynoLast12

"Beertje" <Beertje@discussions.microsoft.com> wrote in message
news:B1B7CC8A-93F1-407E-9592-A779B0296B35@microsoft.com...
>I have a weekly graph showing orders per week. The data of this graph is
> updated weekly. Today to update the graph I need to select the graph, go
> to
> source data and add one more point. Can I have this done automatically?
> Thanks.
>

Thanks.