Stacked Area chart with Min and Max values
Hi,
My sample data looks like:
Month
Actual
Minimum
Maximum
Target
MinColor
MaxColor
BetweenMinMaxColor
1
10
10
12
11
Green
Red
Yellow
2
10
12
15
14
Green
Red
Yellow
3
11
10
12
12
Green
Red
Yellow
4
11
8
10
10
Green
Red
Yellow
5
14
10
15
15
Green
Red
Yellow
6
14
10
15
15
Green
Red
Yellow
I need to create a Stacked Area chart in SSRS 2008 R2 (Express Edition).
There should be three regions in the chart.
Namely
1. below Minimum value
2. between Min and Max value
3. Above Maximum value
I need to set the Fill color for these 3 regions based on the color columns.(Green,Yellow or Red)
Using the above data, how to create Stacked Area chart with above 3 regions?
Please help..
thanks in advance..
Regards, Senthil
June 29th, 2011 10:14am
Hi,
try to Change the Color palette to use these 3colors.Rakesh M J
Dont forget to mark it as Answered if found useful
MCTS,MCITP,MCSS
http://mycubeandreports.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2011 11:31am
Thanks Rakesh.
I know how to set color in Series property.
but i m looking for steps to create Stacked Area chart using the sample data with 3 regions as mentioned.
3 regions in the stacked area chart are:
1. below Minimum value
2. between Min and Max value
3. Above Maximum value
Please help...Regards, Senthil
June 29th, 2011 11:43am
Still i am seeking help on this....Regards, Senthil
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 12:45am
Hi Senthil,
Thanks for your question and Rakesh’s reply. According to your description, my understanding is that you would like use the Actual column
compares to the Minimum column and the Maximum column, if the Actual less than Minimum, the Actual value as
below Minimum value, if the Actual greater than Minimum and less than Maximum, the Actual value as
between Min and Max value, if the Actual greater than Maximum, the Actual value as Above Maximum value, right? If I misunderstand your question, please let me know.
In this condition, I would give you a T-SQL query with the case function, please type it in your Dataset’s Query dialog box,
select
case when Actual<Minimum
then Actual else 0
end as bellow,
case
when Actual>=Minimum
and Actual<=Maximum
then Actual else 0
end as betw
,
case
when Actual>Maximum
then Actual else 0
end as Above
from
sample
Finally, the results just like this:
Hope it helps you, if your issue still exists, please feel free to let me know.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
July 3rd, 2011 3:45am
Thanks Sharp Wang.
But I need to create a stacked bar chart with these three values. When i apply the query result, the chart is not appropriate.
My requirement is:
The stacked bar chart should display three regions: (area)
1. Till Min value
2. Between Min and Max value
3. Above Max value
can you please help on this..
ThanksRegards, Senthil
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2011 6:37am