Showing results for 
Search instead for 
Did you mean: 
rajatahuja Frequent Visitor
Frequent Visitor

Time Line of Cash Flows Visualization



I have an excel sheet with 3 different cash flows(30%,60% and 10% of the project value) at different dates. As an example- suppose total contract value is 100 USD, I receive USD 30 on 15.02.2019. USD 60 on 15.03.2020 and USD 10 on 15.03.2021.I want to present this information in 1 single chart/visualization. It makes sense if I have 3 different line graphs or timeline storyteller-but when I try to combine the  data- X axis(dates) and all the 3 Cash flows (on Y axis),it doesn't make sense-it gets chaotic and moreover the dates only come up for the 30% Cash flow. What can be an solution for such type of data?  



Community Support Team
Community Support Team

Re: Time Line of Cash Flows Visualization

Hi @rajatahuja ,


Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.




Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.