4 Replies Latest reply on May 7, 2018 9:58 PM by Aaron Tan

    Specific color for categories in a bar chart

    Aaron Tan

      Hi,

       

      I am currently having a problem with specifically specifying a certain type of category for a bar chart column.Idea is to have multiple columns of bar chart, where bar chart 1 highlighting a specific category, while bar chart 2 highlight another specific category, while these bar chart will lump all other into a single category.

       

      In a simple visualization:

      Original:

      ->

      For Central I would like to keep both office supplies and technology, East and West only keeping technology and the rest as others, while in south only keeping office supplies, both Furniture and Technology as other. Not sure if it's possible to have this kind of breakdown. I have attached the sample workbook to work on.