Dear Excel specialists,
I have a question.
Currently I am making an inventory of various applications.
All applications will be/are divided in 4 catagories (TIME = Tolerate, Invest, Migrate and Eliminate)
I would like to plot these application names in a quadrant/matrix.
My question is. How can I achieve this? I assume that I have to assign values to all applications, otherwise I cannot make a "dynamic" overview.
I also don't want to have overlapping text in the quadrant/matrix, so I tried to assign an additional value to the application names.
For example:
Quadrant 1
1,1 NameA
1,2 NameB
1,3 NameC
and so on
Quadrant 2
2,1 NameA
2,2 NameB
2,3 NameC
and so on
Quadrant 3
3,1 NameA
3,2 NameB
3,3 NameC
and so on
Quadrant 4
4,1 NameA
4,2 NameB
4,3 NameC
and so on
I downloaded an example that works (please see attached file), based on the information on the left hand side.
But I don't know how to get this working based on the information that I added on the right hand side (left side can be removed afterwards).
Maybe it's just changing the scaling, but I am a little lost now.
Thank you in advance for an answer!
Bookmarks