Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Conditional bar chart in WebI

Hello,

We have a table with the below details

S/N     Company     Category       Profits

1                G             Small             60

2                H             Large             35

3                 I              Large             70

4                J              Medium          80

5                K              Small             40

6                L              Medium          75

I need a column chart in Web-I4.1 which should show

X-axis : Category

3 bars for each of "Small, Medium & Large" count(here count value is 2 for each) and with a condition "differentiate the color of the partial bar if Profits less than 50 and the other partial greater than 50"

Y-axis : Total number of companies(here 6).

Considering the above table, the category "Large" has 2 as count and should show the partial bar with one color and the other partial with other color.

Thanks,

Vishal.

Former Member replied

Hi Vishal,

attached are two files :

The first one is the wid file renamed to .txt so I could upload it and the second is the data provided by you.

This was done in BO 4.1 SP5.

Regards,

Rogerio

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question