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 visual...
tabuzahra i'm sure this can be done using svg which will allow to create own image and size can be done using data. Can you share sample data? What are those background color? What that represents?
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
