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
July 3rd, 2011 3:04am


