Compare the average and individual performance

[668866]

I have a problem about how to display the average value and individual value in the same chart.

I was trying to generate a graph which can show the score trend by time (each week) and by different groups (1,2,3). In excel I can easily get the average trend line of 3 groups, but in crystal reprot, I only can get the individual 3 trend lines by time, I can’t at the same time to show the average value (group 1,2,3 averages each week) line by time. Could somebody give me some help about this?

Thanks you very much for your kind help.

 

[668866]

Please could somebody help to give some ideas?

Thanks!!!