Four quadrant Excel Chart

**Affialho1** · 05-05-2012, 01:23 PM

Hello,
My name is Andrea and I'm new to this forum.
I'm trying to create a chart that depicts the following info in a four quadrant chart. I'm only using the three top and three bottom overall samples.

Value Info Impact Engaging
Sample 1 80% 89% 82% 71%
Sample 2 79% 89% 79% 59%
Sample 3 73% 95% 75% 61%
Sample 4 72% 97% 94% 80%
Sample 5 69% 91% 83% 35%
Sample 6 67% 93% 85% 30%
Sample 7 58% 92% 83% 48%
Sample 8 56% 82% 74% 49%
Sample 9 44% 91% 75% 32%

Please see attached file for what I want the chart to look like. Is there a way to do this? The chart I created I did it manually and the accuracy leaves much to be desired.
Thank you!

**mrice** · 05-05-2012, 05:06 PM

Have you considered using a radar chart? You will find this under the Other Charts button on the Insert ribbon.

**Affialho1** · 05-05-2012, 07:28 PM

Thanks for the tip, but I really need to do it in quadrants...

**npamcpp** · 05-06-2012, 05:43 AM

Hi,

using quadrants, i.e. using an XY scatter chart would require a few more data points and a different data layout. See attached for a suggestion of data layout and chart with the first five series filled in. I trust you'll get the idea. If not, please pipe up.

Add text boxes for the quadrant labels.

regards,

**Jon_Peltier** · 05-07-2012, 11:12 AM

What you seem to have drawn is a 4-spoke radar chart. FWIW, these are notoriously ineffective for displaying information, and people have a harder time reading them than they think they are having.

A parallel coordinates approach is much better. I show how to convert another 4-spoke radar chart into a parallel coordinate chart in Composite Baseball Player Evaluation.