CODEWITHSUNDEEP
reporting-servicesssrs-2012
AndyDudley
AndyDudley

Reputation: 51

SSRS 2012 Report Builder 3.0 Bar and Point on Same Chart

I would like to add points to a stacked column chart as per the attached imagespine chart image. I am able to do this in Excel by changing the data series type for the points to x-y scatter. However in report builder when highlight a series and select change chart type it changes the type for all the series on the chart. Any ideas on how I might achieve this would be much appreciated.

Upvotes: 0

Views: 119

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10870

Unfortunately, the logic between Excel and SSRS are different. The issue seems to be that SSRS says the two chart types are incompatible.

When I try to do it in SSRS 2014, instead of changing one series, it changes them both without giving an error or any other message.

When I hit UNDO and then REDO, it gives an error message. (But it WAD - MS)

enter image description here

The issue seems to be that the Axis of the bar chart doesn't work with the axis from the scatter - probably since the bar chart is one dimensional but the scatter is two.

It does seem to work with a Stacked Bar Chart. Could you use that instead? Make sure you change the Horizontal Axis of the Scatter to Secondary.

MSDN - Multiple Series on a Chart

enter image description here

Upvotes: 0

Related Questions