LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Need a Matrix diagram - Please help

OK guys, gals and gurus -

Here is my project:
In the end, I need a matrix box with 9 boxes containing the following info:

I have 500 companies each with 2 ratings - the spreadsheet looks like this:
Company A 5 2
Company B 5 5
Company C 1 1
Company D 3 5
Company E 1 5
Company F 4 3
Company G 4 5

Matrix Groups 4 and 5 together, 3, 2 and 1 together
Results (I put the Company in parenthesis - I think the matrix would just
have the count).
4-5 3 2-1
4-5 2 (B,G) 1 (D) 1 (E)
3 1 (F)
2-1 1 (A) 1 (C)

I feel like I'm writing a question for the SAT's!
I hope this is clear. I'm looking for counts of how many Companies are rated
a 4 or 5 in BOTH columns (2, Companies B and G). How many Companies are rated
a 2 or 1 in BOTH columns (1, Company C) etc...

Extra Credit: Can this be done with a pivot table that would let you "drill
down" to see the Companies? Or should I just be happy with the counts?

I really appreciate your help in this matter :-)
If there is some magical way of looking at 500 Companies and putting them in
this matrix - I would be very HAPPY.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I transpose nXm matrix to mXn Matrix MIHir Excel Worksheet Functions 2 August 9th 08 11:44 AM
Diagram Kathrine Excel Discussion (Misc queries) 0 March 6th 08 08:56 AM
Insert Diagram Gary''s Student Excel Programming 4 June 7th 06 05:29 PM
Diagram roffe Excel Discussion (Misc queries) 1 May 14th 06 12:01 AM
How can I add third axis to the diagram? nemeza Charts and Charting in Excel 2 December 9th 05 02:22 PM


All times are GMT +1. The time now is 04:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"