1 Reply Latest reply on Oct 22, 2014 6:45 AM by Shawn Wallwork

    Give each geo code the same color in all line and bar charts

    Michael Boldin

      Suppose I have a bunch of tables with time series data for US states labelled by 2 digit code, and each table will be used to create a line chart that will be put in a common dashboard.  How can I guarantee all lines for each state use the same color for a given state ?

       

      I imagine I could create a secondary table with colors chosen for each state

       

      NJ  Red

      NY Blue

      PA Green

       

      and then after a table join by 2 letter code, use some type of conditional formatting.

      I am not sure this is the best step since I will need to complicate the data with the extra join?

      Any examples or suggestions?

      I have not yet attempted conditional formatting and could use an example of this step.