Forum Discussion

bukhari1979's avatar
bukhari1979
Frequent Visitor
8 years ago

Need Help/Idea for Quadrant Chart

Hi

 

I am trying to plot count of companies based on their Sentiments (Positive, Negative, Neutral) on x-Axis and Ratings (1,2,3,4,5,6,7,8,9,10) on Y-axis with 4 quadrants in order to spot the customers who are giving us good ratings but in their comments are not so happy or seem not so satisfied.

 

I will share three images later on this thread

1) Theorotical View of Quadrant chart

2) Manual Output in MS Excel

3) How data looks like

 

The problem with Quadrant Chart by MAQ Software is it accepts sort of numerical value on X & Y axis and reqires to perform aggregate functions like count, ditinctcount on the values dragged into it.

 

Thanks in advance

 

 

Need Help

4 Replies

    • bukhari1979's avatar
      bukhari1979
      Frequent Visitor
      8 years ago

      How it can server as an alternate or replacement to Quadrant chart.

      Any link where I can be referred, so that I can tweak and each my end goal

      • bukhari1979's avatar
        bukhari1979
        Frequent Visitor
        8 years ago

         

        Achieved it today. There is no direct way rather than creating a sub table and playing around with data.

        However, by the grace of God achieve it what I initially was so worried for. Will post all the steps soon