Multiple lines in Y-axes

Discussion created by user16314 on Mar 25, 2012
Latest reply on Apr 4, 2012 by Stephen Huston



I have a table which holds department scores for multiple departments over the 12 months of the year.


I am trying to create a line chart with Months as the X-axes and multiple Y-axes for up to 5 different Department scores.

If I filter my table to nly contains 1 department , I have no issue. The dept scores for each month are shown correctly over the months on the chart.


As soon as I include another department in the table, only the first month's data appears to be shown for both departments.


What am I doing wrong?