Forum Discussion
Solved
Bubble Matrix
Hello,
I'm trying to do a matrix like the one shown below in the image. Where the buble size depends on number of projects Vs Project Status for each client.
I haven't seen any ready made visualization for such thing, and looking forward for your valuable feedback
11 Replies
Hi Parry,
Thanks. Below is a sample data.
In regards of the background color, it represents as following:
- Red refers that the project status for selected clients are (Ongoing - Delayed, On Hold, Completed Delayed)
- Yellow refers that the project status for other than the selected clients are (Complete - Delayed) and for all clients when the status is (Cancelled)
- Green if the status are either (Ongoing - On Track) or (Completed - On Time)
Ongoing - delayed On-hold Completed - delayed Cancelled Ongoing - on track Completed - on time Client 1 27 6 25 4 6 2 Client 2 3 3 3 3 3 Client 3 6 2 1 2 2 Client 4 23 3 23 4 1 1 Client 5 12 4 7 3 5 Other Clients 38 6 23 4 Internal 3 2 7 3 The background color can be represented by the Circle color
