SSRS Column Chart - Label Issue

[wanzek]

I am working on a Chart where the data isn't in an ideal format in the table. There are 13 fields within the table and each represents a column in the chart. My chart setup is as follows:

Series - nothing
Categories - nothing
Values - Sum of Field 1
Sum of Field 2
Sum of Field 3
Sum of Field 4
Sum of Field 5
Sum of Field 6
Sum of Field 7
Sum of Field 8
Sum of Field 9
Sum of Field 10
Sum of Field 11
Sum of Field 12
Sum of Field 13

Each one of the values represents a question on a form that has a 0-2 value associated with it. My chart is displaying properly but I can't figure out a way to get the data labels to show without having a Series or Category. If I add all 13 fields as one of those my data becomes a mess.

Any ideas?

 

[Jacque]

It sounds like a likert scale for a survey.... I might be wrong about that but what if you make the questions your row group and the 'scale' 0, 1, 2 as your column groups.