Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Two columns Y Axis

Hi all, I'd like to put two bars with similar Y axis, one to show the budget value and other a stacked column with three values within. I tried to do it but couldn't put the two together. The resul...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

My pleasure. It's a waterfall chart.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-yingjl I'm struggling to design a graph like yours. Based upon the excel below, how can I have one graph for the column "Grant KBRL" and other three for each other column, like yours?

How is the data in your excel?

 

https://imgur.com/m3fNAXh

 

 

TKs!!!

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi Anonymous ,

    Seems like two different tables in a single file.

    My sample is very simple, just have one tabe like this:

    If there are two tables, I'm afraid it could not achieve it at the same time currently because the total column is an attribute of its own in waterfall chart.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi v-yingjl 

       

      The img that I posted, shows a single table, with that many columns.

      There isn't a workaround using another tool to achieve what I need?

       

      Tks a lot

      • v-yingjl's avatar
        v-yingjl
        Community Support
        6 years ago

        Hi Anonymous ,

        Maybe like this?

         

        Best Regards,
        Yingjie Li

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.