Need Help/Idea for Quadrant Chart

[bukhari1979]

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

[v-chuncz-msft]

@bukhari1979,

You may try using Scatter chart instead.

[bukhari1979]

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]

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

[bukhari1979]