Waterfall chart to show increase and decrease per day

[Rudyi]

Dear all,

Can you please advise if there is a way to build a waterfall chart to show both "Increase" and "decrease" between days?

When I'm trying to build it - I can usually show only "delta" per day, but not so much "+" as "-"

Sample data below

Category Date Amount Increase Decrease

AAA 01.05.20 10000 1000 500

AAA 02.05.20 10500 1500 1000

AAA 03.05.20 11000 1000 1000

Thanks for the help!

[v-yiruan-msft]

Hi @Rudyi ,

What's your expected result? Could you please provide the screen shot to describe it?

---

When I'm trying to build it - I can usually show only "delta" per day, but not so much "+" as "-"

---

Best Regards

Rena

[Rudyi]

Hi @v-yiruan-msft , @AleksanderPunt 

tried to "visualise" it will excel 🙂

[v-yiruan-msft]

Hi @Rudyi ，

I'm sorry I didn't find a suitable waterfall chart that can display data like the chart in your screenshot. Please check if Line and Clustered Column Chart can meets your needs.

Best Regards

Rena

[AleksanderPunt]

Hm, after reading your request once more, I'm not quite sure I understand what you mean by showing both increase and decrease.

I mean, either an article has increased or it has decreased as a total..?

I use waterfall to display monthly development (increase/decrease) as a total for multiple articles.

If I click on a monthly bar, it drills down to display all articles and their individual increase/decrease for that month.

Furthermore, I can click on an article to show increase/decrease per customer for that article, that month.

The monthly sequence can just as easy be weekly or daily.

Perhaps it would be helpful if you drew an example of how you want it to look, and post the picture?

[AleksanderPunt]

Drilldown Waterfall PRO by ZoomCharts will do the trick