Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity 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