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?
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.