Floating Bar in Column Chart

[#1]

Hi,

I have a requirement where I want to show the difference between two values a floating bar in a column chart? Is this something possible in Design Studio?

Thanks,

Prakash

[MustafaBensan]

HI Prakash,

The functionality you have illustrated is not available with the standard Design Studio chart component. You could try the following options:

1. As a workaround, create 2 charts with suitable spacing between the columns and overlay them: one chart for the actual data and the other chart for the variances;

2. Perhaps the standard Waterfall Chart might get you closer to what you need?

3. You can review the SAP Analytics Extensions Directory for partner developed add-on charts that may meet your requirements.

Regards,

Mustafa.

[Vidhya]

Hi Prakash,

If your requirement is to show two different colors in same chart, Please referrer the below blog,

https://blogs.sap.com/2016/11/16/changing-bar-colors-sap-design-studio-1.6/

Using CSS we can achieve it or else based on the data we can achieve it. we have option in the properties got to CSS --> Binding --> Data cell binding option there you can use customize functions.

Regards,

Vidhya.C

[Former Member]

Hi Mustafa and Vidya,

Thanks for your inputs. I will check extensions.

Cheers,

Prakash

[Former Member]

Hi Vidhya,

Thanks for your reply. It is not about showing two different color. As you can see the third column in the screen is not sitting on the X-axis but is floating above the point where the second column reaches its max height.

Any thoughts on how to achieve this. This is a standard functionality available in Excel.

Thanks,

Prakash

[Vidhya]

Hi Prakash,

Since that component is not available in Design Studio.

I will suggested you, please go with "Mustafa" feedback.

or you can check with third party component,

http://visualbi.com/sap-design-studio/dsx-extensions/charts/

Regards,

Vidhya.C