1 of 1 people found this helpful
As your data points are not in one line (each category has different results) you will never have a single line with different coloring.
However, have you tried adding category to rows or column shelf? this way you will have separate 'single lines' for each category.
Second idea is to create separate sheet for each category using filtering.
If it's not the solution you are looking for it could help if you could draw (even in paint) what is the desired output.
If you found this answer helpful please mark this post as helpful.
Can't explain why lines are depicted so "messy" when all Categories ares displayed but find my approach as reference below and stored in attached workbook version 10.0
ParetoChart_Color.twbx 1.2 MB
Maciek is correct.
With different data points this is impossible for any toll.