Conditional background color in line charts

Question

I am currently trying to convert our charts from PQ Systems Chartrunner charts to SSRS 2008 charts. I am currently working with a line chart in SSRS 2008 and trying to change the background color for different sigma. I can calculate and plot the standard deviation sigma lines, but I could not change the background color between the lines.

What I still have in SSRS:

In the Chartrunner chart of the Red / Yellow / Green zone:

Is there a way to do this in SSRS 2008?

Answer 1

Yes, you need to take a look at using Strip Lines in a report:

Highlight data by adding Strip Lines .

This is also a good link:

Axis lines in SSRS .

Since you can use these expressions, stripes can be determined at runtime. It should work in your case, since you always have a certain number of bands, only different values ​​when you run the report.

Here is a simple example based on the following dataset:

Most importantly, I included the max, mid, and min limit lines in the dataset; this makes it easy to create Strip Lines .

Create a simple diagram:

Select the Y axis of the chart and expand the StripLines collection:

You can see that I set IntervalOffset and StripWidth based on the fields in my dataset. Final result:

Thus, you can see that this can be done dynamically as needed. This is a simplified example, but the concept is easily portable; You must be able to adapt it to your requirements.