How to create a visual matrix in Excel

Copper Contributor

Hello!
I would like to create a visual matrix based on 4 data points in an excel sheet.

1. Name of Category

2. Importance of Category

3. Level of Current Satisfaction with Category

4. Time spent on category (size of the bubble)
I'm not even sure if this is possible in excel. Could you please assist?

The matrix should look as follows:

Matrix Example.png

 

1 Reply

@DrJ_Thesising_101 

If you assign number values to satisfaction and importance, you can create a bubble chart.

HansVogelaar_0-1704889143168.png

See the attached sample workbook.