Column Chart Deviation
Hi, Is it somehow possible to create a chart like that (the picture above) with SSRS (2008 R2) ? http://www.hichert.com/downloads/consulting/schaubilder/044_798.pdf i wanna see the differences from the previous year like in the first chart in that pdf (colored in red or green depeding on the sign) I tried a lot with stacked charts and i also found that approach very interesting: http://road-blogs.blogspot.com/2010/04/better-way-of-showing-current-year.html but i wasn't able to create a chart that looks like in the pdf above. Thanks for your help!
April 26th, 2011 4:43pm

can nobody help me? the difficult thing is to make the upper bar thinner than the other one, so that it looks like in the picture.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 2:55pm

Hi, I have checked the example report you posted. Currently, one possible workaround to achieve it is to use the Range Column chart type. For example, we can first add a series to the chart and set its type to Column. This series will be used to represent the profit of current year. Then, we can add another series to the same chart and set its type to Range Column. This series will be used to represent the profit difference. Please be aware we need to specify both Top and Bottom value of a range column chart. In order to make the range column thinner than the basic column, please set its CustomAttributes\PointWidth property less than 0.8. For more information about Range Charts, please refer to http://msdn.microsoft.com/en-us/library/ms155962.aspx Thanks, Tony Chain Tony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
May 2nd, 2011 11:31pm

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

Other recent topics Other recent topics