SSRS align columns of chart to table columns

Question

I have a table in my SSRS report showing several values, followed by a column chart in the last row. I require each chart column to be directly under its respective column. Currently, the columns are all stacked next to each other, and I'm unable to position them on the chart manually. Is there a way this can be done?

Example:

      A  B  C
      1  3  1
      1  1  1
      1  2  1
      1  2  1
Total 4  8  4

         | 
      |  |  | --This is how I want it to appear

         |
        |||   --This is how it currently appears

I want to be able to spread out the columns manually so that I can place each column under its respective table column.

Have you considered creating the columns all in the same table or tablix? — Jamie F
Have you tried adding a new row under the total row and adding a Data Bar to each of those cells? — energ1ser
You might want to have a look at the answers to this similar question: stackoverflow.com/questions/22658791/… — Nathan Griffiths

Raphael Raphael · Accepted Answer · 2014-03-17T08:39:06

I don't know if it's possible to put the bar under the table, but I had a similar problem where I needed to get the bars at the top of my table.

From SSRS 2008R2 in the matrix column group you have the possibility to add a column chart.

You can find the step by step tutorial to this done on the technet site at this link

How to: Display the Same Data on a Matrix and a Chart (Reporting Services)

SSRS align columns of chart to table columns

1 Answers