Liquidity Chart

  • Thread starter Thread starter Zyroth
  • Start date Start date
Z

Zyroth

Hello,

I am quite a beginner with excel and don't have a lot experience with
the terminology, but I hope that you will understand my problem and can
help me. :)

What I have is a table like this:

January 1st, 2001 | 200 €
January 22nd, 2001 | 180 €
January 24th, 2001 | 230 €

What I want now is a chart, which displays the money in my imaginary
puse for each day from January the 1st to January the 24th.
So to speak, there are 200€ in my purse on January the 2nd and 180 € on
January the 23rd.

Is there any elegant way to accomplimish this? I don't want to fill out
the standings for every day, acutally the above table is generated from
a table which is like:

January 1st, 2001 | + 200 €
January 22nd, 2001 | -20 €
January 24th, 2001 | +50 €

Hope someone can help me or at least point me in the right direction. I
already have some programming experience in python, pascal and php but
not in visual pasic wooops basic, yet. So macros wouldn't be too bad.


CyA, Zyroth
 
i think you want to create anothe table with every day listed, and th
data pupulated with a vlookup(date, original data table,2, true). Thi
will fillin the data from the original table for every day - changin
that data when the data in the original table changes.

table 1

date data
1/1 5
1/4 10


new table

date data (this data is brought in via vlookup)
1/1 5
1/2 5
1/3 5
1/4 10
1/5 10


et
 
Back
Top