BusinessObjects Board

Waterfall chart

other Xcelsius - Crystal Dashboard Design
#1

Hi All,

I am trying to create a Waterfall chart in Xcelsius using a stacked column chart…I have seen a post in this forum(the link which i have given below) where it works for positive values…but i have negative values as well in the range…Can we achieve waterfall??

http://forumtopics.org/busobj/viewtopic.php?p=511110&sid=afc05e5981d7038c27aafd8a7ad43feb

Thanks in advance

thehulk200081 (BOB member since 2008-01-13)

#2

do you want the negative values in the X axis or the Y axis?..because yes, you can do this, but it depends on where your values are going to fall.

Cairmor :us: (BOB member since 2008-06-05)

#3

Hi,

the values which i am using can be seen in the picture attached with this post…please see if this can be achievable.

Thanks
WF.JPG

thehulk200081 (BOB member since 2008-01-13)

#4

Please follow the instructions:

  1. Make a range in your excel sheet. Make two rows, one for labels, one for numbers

:…Budget…north…south…east…west…Actual
…6000…-550…-650…1200…670…6200

  1. Get a Stacked Column Chart from component panel. Activate properties.

  2. On the GENERAL TAB > choose “By Series” and click the tiny plus at the bottom of the series box

  3. Select all the numbers ( row2) but not the labels.

  4. On the GENERAL TAB > choose the category lables select button (at the end of the box) and select the labels.

  5. On the APPEARANCE TAB, select the SERIES sub tab.

  6. Set MARKER GAP to 1

  7. Set MARKER OVERLAP to 1

BOOM…free, perfect Waterfall chart.

Cairmor :us: (BOB member since 2008-06-05)

#5

Hi Cairmor,

i tried out your steps but its not showing in the correct way…this is what i got after following your steps…

Please find the attached jpeg

Thanks,
sample.JPG

thehulk200081 (BOB member since 2008-01-13)

Add-on manager
#6

ok, if you need something that looks exactly like that image, then you can make two stacked column charts.

One has the Actual $ Bar, then 4 blank series, then the bar for $ Budget.

The next chart has the 4 series (east / west/ etc), and would be made in the fashion I listed above.

You can remove all visible options for the first chart (e.g. chart area, axis, series names, legend, etc) Put the 2nd on top of the first, and carefully line up the axis, so that the two charts share the same axis. The minimum scale property of the 2nd chart shoule be = (Actual $) * -1, And the size of divisions property should also be = (Actual $)

Addtional formatting will be required.

From an end user perspective, they cannot tell they are looking at two charts.

Cairmor :us: (BOB member since 2008-06-05)

#7

I have achieved the Waterfall chart using the Candlestick chart.

The Candlestick chart has Open, High, Low and Close values. By managing the 4 values you can create the Waterfall effect.

Let me know if you can’t figure it out. I can post my sample.

prasad :india: (BOB member since 2002-08-19)

#8

Hi Prasad,

Can you please post the waterfall chart sample…it would be greatly helpful.

Thanks

thehulk200081 (BOB member since 2008-01-13)

#9

Here is the sample. Hope this is helpful.
Waterfall using Candlestick Chart.zip (7.0 KB)

prasad :india: (BOB member since 2002-08-19)

#10

advertising post removed

To the poster: you may include information in your signature, as you have done. However, you may not post simply to point people to your signature. Your post must contain something of value other than “see sig for solution.” Thanks for understanding.

– Dave Rathbun

cdavies :uk: (BOB member since 2005-01-28)

#11

To create the waterfall chart: Select cells A1:F17 – the heading cells and data – but don’t include the column with the Net Cash Flow numbers. On the Excel Ribbon, click the Insert tab, and click Column Chart, then click Stacked Column

~ If the farmer is poor then so is the whole country ~
Residential Irrigation

jmquet (BOB member since 2015-03-09)