Two different color in single bar in barchart

[#1]

Dear All,

My requirement is, i want to show two values in single bar chart with different colors like below.

I have two expression fields capacity &used and single dimension field container.

Say for example the container A ( My dimension ) of capacity 100% is filled with 30%.I want to differentiate the bar in two colors.

100 should be in one color and in that 30 should be in an another color ( like color in color in single bar ) Like below.

Thanks in advance

[sunny_talwar]

I guess you just need to stack the two charts. and you can do this on the style tab of the chart properties.

Expression1 : Filled Expression

Expression2: Total Capacity Expression - Filled Expression

and select stacked on the style tab

[ThornOfCrowns]

I don't think that's possible. You'll have to either use a stacked chart or have two charts and layer them, I think.

[syukyo_zhu]

Hi,

You can go to your expression,

then background color as attached image. hope helpful

[sunny_talwar]

Something like the attached?

[#6]

Dear Sunny,  I tried this. but i need like what i asked. any possibilites ?

[#7]

Dear James,  I tried this too. layering of two charts is not accepted in my case.  Thanks for your reply.

[sunny_talwar]

I guess I am not sure I understand the requirement, would you be able to elaborate?

[#9]

I have to use the expression only in color sections like back ground color or colors tab instead of expression section to show the used area in different color in same bar.

[#10]

Thanks for your response Sunny.