Forum Discussion
Line style and color for pivot chart with multiple legend items.
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...
Can you please post a picture? This description confuses me a bit.
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.
- I'm afraid I found no way to do that.
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.
