Forum Discussion

tabuzahra's avatar
tabuzahra
Helper II
7 years ago
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...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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?

  • parry2k's avatar
    parry2k
    7 years ago

    tabuzahra here is the 1st attempt at it. Didn't follow the logic for background color since there is nothing as project in your dataset.

     

    But you can look at bubbles and make the changes as per your need.

parry2k's avatar
parry2k
Super User
7 years ago

tabuzahra here is the 1st attempt at it. Didn't follow the logic for background color since there is nothing as project in your dataset.

 

But you can look at bubbles and make the changes as per your need.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How do you do the bubble chart in a matrix?

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous the solution posted here (attached file in previous thread) is showing bubble in matrix, not sure if you had chance to look at it or not. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      My guy, this has been an absolute lifesaver.

       

      I've modified it to do some conditional formatting in the KPI for different colours on the circle. 

       

      Can you help me on how to make the text inside the circles bigger and easier to read?