3 Replies Latest reply on Dec 2, 2016 4:06 AM by Luciano Vasconcelos

    Color Pareto Chart

    Sabine Honer

      Hi all,

       

      I hope you are doing fine.

      I am struggeling to color my Pareto Chart

      As I can't upload my original file ( because of confidential data) I have created an example workbooks based on super sort data.

       

      I have created Pareto chart based on fields Customer Name and Proft.

      Now I would like to color it by category

       

       

       

      Issue is that line will break into three lines.

      I need to have still one line but with colored data points

       

       

      I have tried already with a combined field, but didn't work at all ( can't create even set a secondary calculation on combined field )

       

       

      Is there a way how to color just that "line" by categories?

      For any hint, tips or comments I am really thankful.

       

       

      Best regards

      Sabine