Grouping Excel graph categories
Solution 1:
Short answer is to create 3 different series of data.
Sample (not yours but enough to hopefully get you started)
column A B C
Data 1 1
Data 2 2
Data 3 3
Data 4 2
Data 5 3
Data 6 4
Data 7 3
Data 8 4
Data 9 5
Now you can color the series' different colors, and not have to color each individual point.