Prev: Pivot table range selection changes when opening 2003 xls in Excel 2007
Next: Chart Wizard
From: D.T. Paige D.T. on 22 Jun 2008 04:46
I'm creating a line chart to display the daily progress of a bank account. I
have made a basic spreadsheet for the account, with a particular cell (C1) in
the first worksheet displaying the account balance.

I'd like to arrange the line chart, in sheet two, to update at midnight
daily displaying that current day's balance. What would the
formula/horizontal axis look like in order to do that?

I greatly appreciate any help. Thanks in advance.
 | 
Pages: 1
Prev: Pivot table range selection changes when opening 2003 xls in Excel 2007
Next: Chart Wizard