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?