COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dharmala on 21 May 2014 10:47:18 AM

Title: Conditional Color Palatte for stacked bar chart
Post by: dharmala on 21 May 2014 10:47:18 AM
Hi,

Can someone help me with the stacked bar chart where I am trying to have color fixed to each series in legend. I could see a conditional palatte for pie,area,bubble but couldn't find the property for stacked bar chart.

I need to have a color fixed to each legend series as I am doing sectioning and not all orgs have all the legend series.

Thanks,
Rohini
Title: Re: Conditional Color Palatte for stacked bar chart
Post by: MFGF on 21 May 2014 11:22:55 AM
Quote from: dharmala on 21 May 2014 10:47:18 AM
Hi,

Can someone help me with the stacked bar chart where I am trying to have color fixed to each series in legend. I could see a conditional palatte for pie,area,bubble but couldn't find the property for stacked bar chart.

I need to have a color fixed to each legend series as I am doing sectioning and not all orgs have all the legend series.

Thanks,
Rohini

Hi,

The conditional palette is there - you need to select the Series, and it is in the properties window.

Cheers!

MF.
Title: Re: Conditional Color Palatte for stacked bar chart
Post by: dharmala on 21 May 2014 02:14:09 PM
Hi,

It works  ;D the charts looks as expected but the legend is a bit weird. It shows up the original legend labels and also the conditional palatte legend "Advanced Conditional Expression". How to get rid of the original legend and rename these.

Thanks,
Rohini
Title: Re: Conditional Color Palatte for stacked bar chart
Post by: navissar on 21 May 2014 02:25:43 PM
Yep, that's a known behaviour since forever. What I usually do is take a snapshot of the relevant legend, save it on the server, and then hide all legends and display the snapshot as an image. I wish IBM would take the time to fix this one day.