Need help in 1st WebI Chart - Total sum of stacked bar chart, legend order, colors

[Former Member]

Could someone give me a hint where I could find solutions for the follow issues:

We are on a BEx-queried WebI chart in BO 4.0.

1. I need to display the total sum above of the stapel e.g. 3 stacked values.

2. The 3 values are stacked in order max to min but the legend changes not in the coresponding order. It stays on the original order.

3. Could I implement a user specific color palette?

Thanks for your advice

Thilo

[sateesh_kumar1]

Hi Hertner ,

1. I need to display the total sum above of the stapel e.g. 3 stacked values.

by default you can't.create 3 blanks cell with your measures and place them exactly on the bar.(little formatting may required)

2. The 3 values are stacked in order max to min but the legend changes not in the corresponding order. It stays on the original order.

If I understand correctly ,you are looking for change in the key figure order .This you can change at the assign data - change order of display ,

3. Could I implement a user specific color palette?

No.Only one pallette for chart

[Former Member]

Hi Sathish,

thanks for your answers. I followed your advices. On point 3 I found the installation-guide for a corporate specific pallette for the tomcat. This works also fine.

Greetings,

Thilo

[sateesh_kumar1]

Hi hertner,

Close this thread if you got correct information

[Former Member]

How can I do the closing of this thread?

thx

[sateesh_kumar1]

when giving reply to your own thread it will show you two radio buttons, one for not answered and another for answered. chose the answered radio button. then your thread is closed. post your solution before closing a thread, its useful for others.

[Former Member]

As you can see in the image below, there are no radio buttons. Not in the reply on my one post nor in the reply to your post.

Thanx for more advice.

Thilo

[former_member158249]

Hi Sateesh,

I am also implementing a Stacked Column Chart, but in value axis I have a single measure. Can still I implement totals at top of each bar? I have more than 50 suppliers.

Regards

Sushant

[sateesh_kumar1]

Hi Sushant,

Create a vertical table with Period and Electivity Use CO2.

format exactly with column chart .Place above to columns as they seems part of chart.

[former_member158249]

Hi Sateesh!

Thanks for your prompt reply!

I already tried implementing this idea, but in my case I have Month-Year in Category Axis and the business user will be filter Month-Year from input control, hence the width of the bar changes based on selection and charting area remain same but the vertical table shrinks. Hence this does not work out in my case

Regards

Sushant

[sateesh_kumar1]

Yes shushant ,I agree with you .This only works for canned report .