4 quadrant graph

[bricer]

I am trying to create a graph that I call a '4 quadrant graph' where axes X is a range from 0-10 and axes Y is also 0-10. If axes X = 6.5 and axes Y = 8.8 for a given data range I would like them to be plotted as a single value on the graph where they meet. How do I do this?

 

[Andrew Poulsom]

Do you mean an XY Scatter chart?

 

[bricer]

YES.. But I can not get the 2 values to meet, and then show that point as a label representing to data. Each value is a single cell on the spreadsheet. What am I doing wrong?

 

[bricer]

YES.. But I can not get the 2 values to meet, and then show that point as a label representing the data. Each value is a single cell on the spreadsheet. What am I doing wrong?

 

[Andrew Poulsom]

For an XY chart you need X values eg 6.5 and Y values eg 8.8.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190

 

[bricer]

Maybe I'm not explaining myself properly. I am trying to achieve the following:
http://www.gmr-search.com/diligencequad.pdf

in excel so I do not have to create this graph is something else.

 

[Andrew Poulsom]

That has x and y values - Capability and Retention and Stability.

Here is a quadrant chart:

http://peltiertech.com/Excel/Charts/BackgroundFill.html#Quadrants

You should be able to find how to get the other cosmetic features on that site.