Line style and color for pivot chart with multiple legend items.

[RuedigerMeyer]

I have a pivot chart with 2 entries in Legend (Series). I would like to have the first entry determine the line style (solid, dashed, dotted, etc ) and the second one determine the line color.

So if for instance the first entry has 4 values and the second one has 5, I would expect 4 different styles and 5 different colors for the 20 lines. Instead I get 20 different colors, which is not a very useful way of representing multi-dimensional data. Is there a way to change this? 

[#2]

Can you please post a picture? This description confuses me a bit.

[#3]

@JKPieterse 
Hi, here is an example with 2*4 curves. I would want the first value in the combined label drive the line style, and the second one drive the color. So because 1-b is some sort of dark green, 8-b would be that color as well, but dashed, instead of purple and solid. Because 1-f is orange, 8-f would become dashed orange instead of solid light green, etc.

This would make the graph much more intuitive. 

[#4]

I'm afraid I found no way to do that.

[#5]

Just to clarify, I know how to manually format the chart, below is how it would look like. 

I only wish there was the option to automatically get a sensible scheme of colors and styles to represent multiple legend dimensions.

@RuedigerMeyer