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

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/

Still i am seeking help on this....Regards, Senthil

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.

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