I'm trying to set up a report for displaying employee scores in various categories. In the report wizard, I set the grouping to employee and add the score categories as columns with summary type of "Average". I also select the bar graph representation. However, when I render the report, it only shows the first score category as a bar for each employee. Instead, I need all of the score categories I selected to appear as bars per employee. How can I achieve this?


Setting the second Y axis value will display 2 bars per employee, but is there a way to have more without making a custom report?