Chart for Library Student Occupency Chart

Thanks for getting back, and sorry for any confusion earlier.

To clarify, the standard Scatter Chart in Power BI can be used to some extent, but it has limitations - especially when it comes to showing seat numbers inside the bubbles and customizing the bubble size and color based on different conditions.

You can:

Use X and Y fields to position each seat

Use Shift_Size for bubble size

Use Color or Status for the legend

But the default scatter chart doesn’t support showing seat numbers inside the bubbles directly.

For better results, please try these Custom Visuals:
  1. Scatter/Bubble Chart by xViz.
  2. Bubble chart by xViz.
  3. Bubble Chart with Categorical Data.

If you're exploring this in Excel, for better guidance, we suggest posting in the Excel Community.

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider to give a kudos and Accept as the solution to help the other members find it more quickly.

Thank you.