COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Revathi_M on 30 Nov 2014 10:51:00 PM

Title: Line Chart Dynamic Background Color?
Post by: Revathi_M on 30 Nov 2014 10:51:00 PM
HI Any body Export Help me.

I am using 10.2 version

I have Line chart Depending Condition i need Display different Colors
My string Varibale:
Case
When [Query1].[TARGET]  <=  20 Then 'Red'
When  [Query1].[TARGET] >=  20  and  [Query1].[TARGET] <=  40  Then 'Yellow'
When  [Query1].[TARGET] >=  40  Then 'Green'

end

I am Selected Chart Properties:in "Conditional palette" Then "Gradient" is given colors it work only Marker but i need Background color


Please Anybody explain me
and also Line also i need dynamic color

Thanks
Revathi_M
Title: Re: Line Chart Dynamic Background Color?
Post by: MFGF on 01 Dec 2014 07:57:41 AM
Quote from: Revathi_M on 30 Nov 2014 10:51:00 PM
HI Any body Export Help me.

I am using 10.2 version

I have Line chart Depending Condition i need Display different Colors
My string Varibale:
Case
When [Query1].[TARGET]  <=  20 Then 'Red'
When  [Query1].[TARGET] >=  20  and  [Query1].[TARGET] <=  40  Then 'Yellow'
When  [Query1].[TARGET] >=  40  Then 'Green'

end

I am Selected Chart Properties:in "Conditional palette" Then "Gradient" is given colors it work only Marker but i need Background color


Please Anybody explain me
and also Line also i need dynamic color

Thanks
Revathi_M

Hi,

Can you explain what you mean by background colour? A cart can have only one background, so how can it be different colours for different values? Can you explain?

The image of the chart you included seems to be exactly what I'd expect to see...

MF.
Title: Re: Line Chart Dynamic Background Color?
Post by: Revathi_M on 01 Dec 2014 11:27:23 PM
Hi MFGF,
I need Background color is depending my case statement
that also Dynamic Background color
please check my attachment
Case Depending my y-axis values


any other way like HTML?

please Help me.

Thanks
Revathi_M
Title: Re: Line Chart Dynamic Background Color?
Post by: MFGF on 02 Dec 2014 04:41:12 AM
Quote from: Revathi_M on 01 Dec 2014 11:27:23 PM
Hi MFGF,
I need Background color is depending my case statement
that also Dynamic Background color
please check my attachment
Case Depending my y-axis values


any other way like HTML?

please Help me.

Thanks
Revathi_M

I *am* trying to help you. I already advised you that a charts can only have one background - the whole thing can be conditionally styled (ie all red, all yellow or all green) but you cannot define multiple conditional colours because the background is not split into different sections. You could create a fixed background image with a gradient from red to yellow to green, but it would not be based on a condition.

MF.
Title: Re: Line Chart Dynamic Background Color?
Post by: BigChris on 02 Dec 2014 06:41:50 AM
As MF says, you can't colour the background for the chart. You could put base lines in and colour those, so you'd have a red line at 20 and a yellow line at 40...that's probably as close as you're going to get.
Title: Re: Line Chart Dynamic Background Color?
Post by: Revathi_M on 02 Dec 2014 07:26:24 AM
Hi BigChris;

Please Send me how to do line;
i done Marker it fine but line can send senario?


Thnaks
Revathi_M
Title: Re: Line Chart Dynamic Background Color?
Post by: BigChris on 02 Dec 2014 08:10:40 AM
They're in the chart properties section - see attachment
Title: Re: Line Chart Dynamic Background Color?
Post by: MFGF on 02 Dec 2014 11:25:33 AM
Quote from: Revathi_M on 02 Dec 2014 07:26:24 AM
Hi BigChris;

Please Send me how to do line;
i done Marker it fine but line can send senario?


Thnaks
Revathi_M

If you already know how to add Markers using the Markers property, why do you need step-by-step instructions on how to add baselines using the baselines property? They are virtually identical. Is there a reason you're not willing to try on your own? I understand that you may be under pressure, but you really can't expect people on here to spend their own time doing your job for you while you apparently make no effort to understand and investigate the valuable pointers you have been given. I notice you didn't have the courtesy to thank Chris for his advice, too.

MF.