Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Quadrant graph in Excel 2007? 1

Status
Not open for further replies.

KristieLee1

Technical User
Jul 13, 2009
76
US
Anyone have any idea how to make this in Excel? I can't seem to find anything in the help files or on the web. How to's or links are appreciated. Thank you!
 


A quadrant chart is an x-y scatter chart.

Can you post some sample representative data and the extpected results for that data?

Please use TGML tag [tt][ignore][tt] ... [/tt][/ignore][/tt] so that everything lines up as intended.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
And Skip beats me to it again!!!!

Cheers, Glenn.

Beauty is in the eye of the beerholder.
 


Got no scatter in my gray matter! ;-)

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Ummm...tgml? is that like ttyl? (I'd appreciate any education you can provide on this topic as well) ha uh ha...moving on. Here is the data I have...in the format I have. lol Sorry Skip.
I get the whole scattered, ordered pair thing, just don't know how to make the quads in excel. I'll look at the links provided. Each city is ranked by rev and enrollment. Just because they rank 1 in rev, doesn't mean they are 1st in enrollment. If that makes sense. Thanks again to all.

DMA Rank1 Rank2
Boston, MA 1 2
New York, NY 2 1
Philadelphia, PA 3 7
Chicago, IL 4 6
Los Angeles, CA 5 11
 
I see how crappy my data came across. Please educate me on the tgml, so that I can avoid this mistake here in the future. Thank you.
 



what VALUES represent each quadrent?

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
q1=high rev/high enrollment
q2= high rev/low enrollment
q3=low rev/high enrollment
q4=low rev/low enrollment

I only included a small sample of my data. I have about fifty cities.
 


VALUES?

And how does RANK relate to either rev or enrollment?

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
The values are the ranks. What city is first for enrollments what city is first for revenue.
I've ranked the enrollment and revenue by city already, and just need to plot them.
I think I'm getting it...but appreciate the dialog.
 
Boston should be 1,2 ordered pair and be in the upper right quadrant.
LA should be 5,11 and appear in the lower left quadrant.

Now I'm getting confused. sorry
 

Boston should be 1,2 ordered pair and be in the upper right quadrant.
LA should be 5,11 and appear in the lower left quadrant.
Your chart axes x,y values (all positive)...
[tt]
12 |
11 | *LA
10 |
9 |
8 |
7 |
6 |
5 |
4 |
3 |
2 | *BOSTON
1 |
+------------------------
1 1 1
1 2 3 4 5 6 7 8 9 0 1 2
[/tt]
So I AGAIN ask the question:

What VALUES are associated with what quadrents: q1, q2, q3, q4?

WHERE are the quadrents located? (ie MY q1 may be in a different quadrent than YOUR q1)

You may need to REVERSE the rank.



Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
I have no idea what values are associated with the quadrants. I didn't think I could set that anywhere, and wouldnt know how to anyway.
I was attempting to figure out the location of the quadrants, and what determines those values as well. I used the link and followed the example, which walks you through making the quads, but I have no idea what values are associated with each.
All values are positive. I'll reverse the ranks as well.
Thank you Skip. Sorry I'm not communicating this well. IM anyone? lol
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top