Hi All,
I have some data of incoming and outgoing cash flow from our company and i'm wanting to see this data in a waterfall type of chart. I understand that the data in itself might not be set out in the best way in order to create a waterfall chart, if this is the case, can you please advise?
The table is set up the way it is as we have different people entering data on the same document at different times. If you see the attached copy of ours you'll see what I mean.
In the first section (Colums A-E) our customer co-ordinator will input the customer name, the amount to be paid and the date the payment Is due. This section is updated daily
In the second section (Colums F-H) our wages dept enter the wages per week and also PAYE, Pensions and fuel amounts - This section Is updated weekly
In the final section (Colums J-L) our accounts chap enters in the supplier payment name, amount to be paid and date to be paid.
Lastly In Cell B1 we have the bank account starting balance.
What I've been trying to achieve (for several days now ) is a waterfall chart that will have the dates of the month along the bottom, and money in account on the Y axis. So on the 1st of the month it will have the starting amount, then the data will be sorted into date order (somehow!!) and then shown going up and down through the month as customers are paid and as we pay wages and suppliers.
Is this possible or am I dreaming!!!??
Bookmarks