currently i have the following chart: It currently contains one column (blue one) and a range column (white one). But what i really need is a chart which looks like the following: So the white column should be overlapped by the blue column. I tried to change the range column to a normal column and changed the "CustomAttribute" PointWidth but was not able to get my chart looking like the needed chart. Does somebody knows how to do that? Thanks @glh: I know that, it currently looks like this (changing the white range to column): ANGEFALLEN = blue column EINGEPLANTV1 = white column Problem is that the white column is now right to the blue column. If i change the order of the chart data the blue column ins right to the white column. But i need the white column to be behind the blue column like shown in the second picture of the main post / question. Followup 25.04.2013: The chart should look like this: I need to move 1/3 of the white column behind the blue column so that 2/3 of the white column is still visible. The blue column has to be in the foreground and the white column in the background.

Reputation: 449

SSRS overlapping column chart

currently i have the following chart: enter image description here

It currently contains one column (blue one) and a range column (white one). But what i really need is a chart which looks like the following:

enter image description here

So the white column should be overlapped by the blue column. I tried to change the range column to a normal column and changed the "CustomAttribute" PointWidth but was not able to get my chart looking like the needed chart.

Does somebody knows how to do that? Thanks

@glh: I know that, it currently looks like this (changing the white range to column): enter image description here

ANGEFALLEN = blue column EINGEPLANTV1 = white column

Problem is that the white column is now right to the blue column. enter image description here

If i change the order of the chart data the blue column ins right to the white column. But i need the white column to be behind the blue column like shown in the second picture of the main post / question.

Followup 25.04.2013:

The chart should look like this: enter image description here

I need to move 1/3 of the white column behind the blue column so that 2/3 of the white column is still visible. The blue column has to be in the foreground and the white column in the background.

Upvotes: 1

Answers (2)

marky-b

Reputation: 304

Overlapping Series:

Change the "overlapping" series to a "Range Column" chart type. This will allow you to layer the two series on top of each other.

Once you do this, you will notice that the series will get two value drop-downs:

Range Column Series with multiple value drop-downs

Set the "Low" drop down to an expression with the value of 0.

Set the "High" drop down to the value you would like to represent.

Offset Series Position:

I am actually not sure if this is possible in SSRS. However, you can play with the widths of the layered series to achieve a similar effect.

Series Column Width

Set the PointWidth propety of the series (under CustomAttributes) either larger or smaller than the default .08, depending on your desired effect.

Here is a quick mockup I put together. It isn't exactly what you were looking for, but maybe it'll get your creative brain juices flowing.

enter image description here

Upvotes: 3

glh

Reputation: 4972

You should be able to drag the values around in the values box or there will be a blue up or down arrow to alter the order your data is displayed. See below for an example of what you will see when you select the charts data.

enter image description here

Upvotes: 1

SSRS overlapping column chart

Answers (2)

Related Questions