extend graph axis automatically in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alv_C - 12 Oct 2006 19:01 GMT

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?

Reply to this Message

Kelly O'Day - 13 Oct 2006 03:16 GMT

Alv_C

> You can automatically update your charts when new data is added by using
> dynamic range names.
[quoted text clipped - 5 lines]
>
> Kelly

>I enter in weekly financial numbers to display data trends in a graph using
> excel.
[quoted text clipped - 7 lines]
> Is there a way to save me some time using some formula that reads the
> spreadsheet and updates it on its own?

Reply to this Message