How do I set up an automatic calculation by date in Excel?

D

D.T. Paige

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top