Can I make portion of the bar a different color?

[shyamcharan]

Hi Experts,

Just wondering if I can make part of a bar in a bar chart different color?

A simple scenario,

I would have one dimension with one year '2012'.

I would add two expression that show two bars for example activities and responses as shown in the attached qvw.

Can i show a different color on the second bar only that portion of the bar, i.e a difference in activity and response value portion?

I want to show the more number of responses than activites.

Thanks heaps in advance.

Shyam.

[Anonymous]

Hi shyamcharan,

You can show only the difference between Activities and Responses, then set the bar offset equal to activities.

On Responses I've used Dual function to set difference value, but to show only Response value.

Shoy my attached example.

Kind regards!

[bindu_apte]

Hi,

You can make changes like this.

You can select the colour and change only for second bar chart.

[maleksafa]

why don't you use the stacked option, if i understood your request, you want to show the difference between the activities and responses.

check the attached, if it is a good option.

[shyamcharan]

Thanks Malek,

The user requirement is to show the values for both activity and responses along with the variance when exported to excel or when flip to table.

[tamilarasu]

I hope you are looking for stacked bar chart like attached.

[shyamcharan]

Thanks Nagaraj,

But no my requirement is different to the stacked bar chart.

[Anonymous]

Hi shyamcharan,

Have this helped to you?

Thanks.

[Digvijay_Singh]

I think you cannot have one bar with two different colors but you can set offset value to change the start position to highlight the difference. The waterfall like below as explained in developers cookbook using offset helps to compare different bars.

[shyamcharan]

Hi Manuel Capella,

Thanks for the quick response.

Yes looks like this could be my work around.

Thanks heaps.

Shyam.