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 andEliminate)

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 11,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