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?