Forum Discussion
Time Line of Cash Flows Visualization
Hi,
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?
1 Reply
- v-frfei-msft
Community Support
Hi Anonymous ,
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.
Regards,
Frank