Forum Discussion
DrJ_Thesising_101
Jan 10, 2024Copper Contributor
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:
1 Reply
Sort By
If you assign number values to satisfaction and importance, you can create a bubble chart.
See the attached sample workbook.