I enter in weekly financial numbers to display data trends in a graph using
excel.

I have not found a way to update the graph's range automatically, and it is
a bit time consuming to go into each graph and each line graphed and upadate
the axis' range by hand, one at a time.

Is there a way to save me some time using some formula that reads the
spreadsheet and updates it on its own?

Alv_C

You can automatically update your charts when new data is added by using
dynamic range names.

This link and download explains how to create dynamic range names and
walks you through an example similar to your situation.

http://processtrends.com/pg_dynamic_charts.htm

Kelly

"Alv_C" wrote in message
...
I enter in weekly financial numbers to display data trends in a graph using
excel.

I have not found a way to update the graph's range automatically, and it
is
a bit time consuming to go into each graph and each line graphed and
upadate
the axis' range by hand, one at a time.

Is there a way to save me some time using some formula that reads the
spreadsheet and updates it on its own?