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

Question

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?

jkpieterse · Answer

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

ruedigermeyer · Answer

JKPieterse&nbsp;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.&nbsp;&nbsp;