Grand total column for waterfall charts

Thomas Ejlerskov

February 08, 2022 13:43

Hi Targit

Is it possible to make a grand total column for waterfall charts in Targit?

Below is an example of how it is done in Excel (10+20+30 = 80)

I have been looking through the chart properties, but is not able to find it. Is it possible to do it? :-)

/Thomas

2 comments

Marlene Knaup
February 08, 2022 15:20

Hi Thomas,

I think it is not possible in a waterfall diagram. But maybe someone else has an idea?!

First though about a right axis for the total value, but in this chart type there is only one axis possible.

Best regards

Marlene

0
Ole Dyring
February 09, 2022 08:10 (Edited December 12, 2023 11:51)

Hi Thomas,

With a bit of calculations, it is possible.

I encourage you to have a look at our 'Inspiration portal', https://solutions.targit.com.

For waterfall charts, more specifically at https://solutions.targit.com/default.aspx?doc=vfs://Global/TARGIT%20Demo/Charts/Waterfall%20Charts.xview.

Here, you have an example of a Waterfall chart with an Initial value and an 'End of period' value (which is equal to your request for 'grand total').

Also, notice the 'Play' button in the upper right corner of the chart. This will direct you to an instruction video on how the example waterfall chart was designed.

Direct link to video: https://youtu.be/A_TyPOJKyBs

Let me know if this was useful.

BR / Ole

0

Please sign in to leave a comment.

New post