Forum Discussion
How to create a visual matrix in Excel
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:
If you assign number values to satisfaction and importance, you can create a bubble chart.
See the attached sample workbook.
