Quadrant Chart nightmare

Hello All,
I have been asked to produce a quadrant chart, I am completely clueless about how quadrant chart works please see data I want plotting, any advice would be greatly appreciated.


X Y
14.29% 46.15%
16.28% 53.85%
0.00% 0.00%
11.69% 47.37%
16.19% 51.52%
0.00% 0.00%
0.00% 0.00%
0.00% 0.00%
7.95% 46.67%
0.00% 0.00%
12.70% 44.44%
0.00% 0.00%
10.66% 39.39%
13.13% 36.11%
0.00% 0.00%
0.00% 0.00%
18.92% 25.93%
24.00% 60.00%
18.75% 42.86%
0.00% 0.00%
0.00% 0.00%
11.57% 44.64%
0.00% 0.00%
16.07% 39.13%
8.16% 50.00%
0.00% 0.00%
0.00% 0.00%
0.00% 0.00%
0.00% 0.00%
5.93% 50.00%
8.26% 33.33%
16.08% 46.94%
5.99% 38.10%
0.00% 0.00%
0.00% 0.00%
10.98% 47.37%
7.44% 40.91%
0.00% 0.00%
0.00% 0.00%
16.46% 41.94%
17.95% 63.64%
14.71% 41.67%
17.68% 47.06%
8.93% 52.63%
12.77% 75.00%
10.13% 56.10%
11.34% 45.83%
19.80% 46.51%
15.85% 43.28%
0.00% 0.00%

Thanks for the valuable advice I will give it a go, please see attached the data I am trying to chart, I am also trying to add the p codes on the chart but I am not sure whether that's possible.

Many thanks
Regards
M

Originally Posted by teylyn

Hello,

a quadrant chart is an XY scatter chart with a big cross in the center.

In most cases, this cross divides the positive and the negative values for both the horizontal (X) and the vertical (Y) axes.

There may be scenarios where the crossing point sits at other thresholds for X and Y.

As a guideline, create a XY Scatter Chart with your data. Use helper series to create the vertical and the horizontal lines of your specific quadrant thresholds. If you plot the data first, you will know where to put the cross.

For the vertical line you need a series with two X/Y data points. The two X values (horizontal position) are the same and the two Y values (vertical position) are 1 and 0 (or another combination of one high value and one low value).

For the horizontal line you need another series with two X/Y data points. This time, the two Y values (vertical) are the same and the two X values (horizontal) are 1 and 2 (or whatever suits the axis settings)

You may want to put the series for the cross on the secondary axis, so you can use the axis settings min and max values to control where exactly the lines show.

If all of the above was too much for you, don't fret. Nobody was born with that kind of knowledge. Some people just have spent more time learning about it. If you would like to learn about how to do this in your spreadsheet, please post a sample file with some dummy data (no real names please) and we can take it from there.

cheers,

I would like to produce a chart with a cross in the middle that shows the spread of values across the x and y axis, sorry if I come across like somebody who is not too sure what she is talking about, still trying to get me head around this.

Many thanks
regards
M

Hi many thanks for getting back so quick, is it possible to have the cross at x axis 12 and y axis 37.5.

Many thanks
regards
M

Perfect thanks you so much for helping me out, I greatly appreciate all the quick responses you provided.

regards
M