4 Replies Latest reply on Jun 27, 2016 8:11 PM by Nicholas Gorman

    Help with Formatting

    Nicholas Gorman

      Hi Everyone,

       

      I need some help with coloring some fields in a very particular way.

       

      The goal is to have each row be the sum of people who responded either positively or negatively to a certain question. (Image attached with stacked bar graph look.)

       

       

      The data is layed out so that each column is a particular question, and each row is a customer. (Mock data attached)

       

       

      CustomerQ1Q2Q3Q4
      cust-12012
      cust-21222
      cust-31212
      cust-42010
      cust-51111
      cust-62021
      cust-71120
      cust-82011
      cust-91200
      cust-100100
      cust-111010
      cust-120221
      cust-130201
      cust-142222
      cust-150220
      cust-162020
      cust-171200
      cust-181201
      cust-192200
      cust-200000

       

      If a one is next to the customer, they said that they had a positive experience with that aspect of the business. If there is a 2 they they said that they had a negative experience with that aspect of the business. A zero means they did not have an opinion about that aspect.

       

      I have managed to align the data so that I can color this for one row at a time, but cannot for all of the rows on the same graph.

       

      I cannot do individual sheets and put them all into a dashboard.

       

      Any help would be appreciated!

       

       

      Thanks,

       

      Nick