Feb. 28th, 2012

Uncharted

Feb. 28th, 2012 02:54 pm
rowyn: (studious)
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?

August 2025

S M T W T F S
     12
345 6789
10111213141516
17181920212223
24252627282930
31      

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Aug. 25th, 2025 07:55 pm
Powered by Dreamwidth Studios