Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS Column Chart - Label Issue

Status
Not open for further replies.

wanzek

Technical User
Mar 8, 2010
58
US
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?
 
 http://files.engineering.com/getfile.aspx?folder=525100ae-70db-4195-9833-cd90b89528ba&file=Chart.JPG
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top