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
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.
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
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.
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.
Hi BigChris;
Please Send me how to do line;
i done Marker it fine but line can send senario?
Thnaks
Revathi_M
They're in the chart properties section - see attachment
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.