1 Reply Latest reply on Oct 11, 2018 12:26 AM by Mahfooj Khan

    Show industry on the map

    Seul Bee Jeon

      I have four columns on my excel spreadsheet.

       

      Company Name

      Headquarters State

      Industry

      Revenue

       

      I want to show the industry in different colors on the map and each state will show one industry that has the highest revenue (sum).

      For example, New York and North Carolina have the highest revenue in the financial industry (financial industry will have red color on the map - so NY & NC will be red on the map).

      Tennessee and New Jersey - The revenue in healthcare is the highest - show up with blue color on the map

       

      Each industry will show up on the map with different color and each state will have the industry that represents the state.

       

      How can I generate this?