Skip to main content
Question

Color-Code a Series in a Chart if the series is a Report Formula

  • August 4, 2022
  • 0 replies
  • 244 views
Hello! I'm making a bar chart and grouping like objects with a report formula. For example, all store types that contain the word "New," I want them to just be called "New." We have New-A, New-K, New 5.1, etc. I have created the summary formula, so the series does work. However, the report gives the "New" doors an automatic color that I can't seem to easily change. Does anyone know how to do choose the color or even know if it's possible?

Thank you!

------------------------------
Amber Gartner
------------------------------
    This topic has been closed for replies.

    I've got the same issue; my horizontal bar chart has 2 series determined by a report formula, 5 rows match 1 series and the 6th row is the "leader". 

    I get 2 colors, blue or black depending on the alpha-sorting of the value I put into the report formula.

    It looks like highchart is blue for series 0 and black for series 1 and there's nothing i can do about that.

    Sure would be nice to be able to give my chart a punchier color for the report leader!



    ------------------------------
    Peter Surplice
    ------------------------------
    Terms & ConditionsAccessibility statement