pivot chart line colours by category

Copper Contributor

temp.PNG

 

Can I select something to automatically colour the lines by Column.     

e.g. all of the Col1 lines red and all Col2 lines blue.

 

I could do it manually but my actual example has many more lines.

0 Replies