Overlapping Series in Range Charts in SSRS
Hi, I have a Range Chart as shown as shown below. I am trying to highlight the category group in any way possible. One solution is explained in the blog "Overlapping Charts in SSRS using Range Charts" http://road-blogs.blogspot.com/2012/03/overlapping-charts-in-ssrs-using-range.html But this is for bar chart. I have a range chart, can we implement similar solution for Range Charts? If not, is there any otherway we can highlight the category group? Thanks NC
August 3rd, 2012 4:10pm

Hi gownam, Sorry for the delay. Based on my test, if we add two fields in to the Values area in a Range chart, the series for the two fields wil be displayed alternately. That way, we are unable to set the overlapping by using the method provided in the blog. In this case, I am afraid the closet approach is to add a set of Bar chart type series and set the Bar chart type series as the innermost layer. Let's assume the three fields in your chart is "Year", "Quarter", and "Val". Then, you can refer to the steps below: Create a Rang Chart as the screenshot above shows.Right click the series in the Values area, change it to Bar Chart type.Right click the modified series, open the Properties window, set the "Category field" to "[Year]". Set the "Value field" like below: =Switch(Fields!Year.Value="2009", 50,Fields!Year.Value="2010",60,Fields!Year.Value="2011",75)In the Series Properties window, click the "Legend" tab, check the "Don't show this series in a legend" option.Click the Plus sign in the Values area and add Val field to the area. Right click the newly added series in the Values area, change it to Range Chart type.Open the Properties window of the new series, set the proper "Bottom value" and set the "Category field" to "[Year]". The screenshot below is for your reference: Hope this helps. Regards, Mike YinMike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2012 8:27am

Thanks. That works perfectly.NC
September 18th, 2012 3:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics