Line Chart Dynamic Background Color?

[Revathi_M]

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

[MFGF]

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.

[Revathi_M]

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

[MFGF]

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.

[BigChris]

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.

[Revathi_M]

Hi BigChris;

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


Thnaks
Revathi_M

[BigChris]

They're in the chart properties section - see attachment

[MFGF]

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.