Rowyn (rowyn) wrote,
Rowyn
rowyn

Uncharted

So I have data that looks like this:

Date Balance
1/1/11 0.00
6/6/11 5,000.00
6/10/11 0.00
7/1/11 50.00
7/12/11 0.00
8/14/11 15,000.00
9/15/11 0.00
12/5/11 5,200.00


The date column is the day that the balance changed. That balance is the account balance until the next date appears.

I want to have Excel do a chart that reflects this: eg, shows the balance is zero from 1/1/11 to 6/6/11, then that it’s $5,000 for four days from 6/6/11 to 6/10/11, then zero again, etc. Now, if I manually add every single day in the year to my data and manually include the balance for each date, I can get Excel to do this. But I would really like to do it without having to make 365 rows of data. x.x

By default, bar graphs will treat my points as if they represent only that day’s data, and that all other days have a value of zero. Line graphs will by default draw a gradual rise and decline over time, which is also wrong.

It seems like this is an obvious sort of problem and there should be an obvious sort of solution to it, but I am just not figuring it out. Anyone know how to do this?
Subscribe

  • Feeding Time

    The biggest downside of replacing my waterbed mattress with a foam one is that I'm no longer sleeping on a giant hot water bottle in the winter. My…

  • Ash

    She's gone. She became unresponsive over the course of the day. Lut called me at 4:30 to say she was convulsing. We took her to vet. She was…

  • Almost Done

    I think Ash is going to die soon. Just a couple of days ago, I was thinking that she seemed stable. In very poor health, but ... stable. She was…

  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 4 comments