How to create a visual matrix in Excel

Copper Contributor

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


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


See the attached sample workbook.