Forum Discussion

RuedigerMeyer's avatar
RuedigerMeyer
Copper Contributor
Sep 10, 2024

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 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? 

 

4 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Can you please post a picture? This description confuses me a bit.
    • RuedigerMeyer's avatar
      RuedigerMeyer
      Copper Contributor

      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. 

       

      • RuedigerMeyer's avatar
        RuedigerMeyer
        Copper Contributor

        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 

Resources