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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
4 quadrant graph
- Thread starter bricer
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Do you mean an XY Scatter chart?
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
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
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190
Upvote
0
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.
http://www.gmr-search.com/diligencequad.pdf
in excel so I do not have to create this graph is something else.
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
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.
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.
Upvote
0
Similar threads
- Solved
