Forum Discussion
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.
Hi MayAnk__Rathi ,
1. Create a helper table with all 70 seat numbers and a formula that checks if the seat is occupied and shift type, based on today's date compared with Column J (=IF(J2<TODAY(), "Vacant", ...)).
2. Add columns to determine:
- Occupancy status (Occupied/Vacant)
- Shift type (Full/Morning/Evening)
- Circle size (use a helper field with values like 2 for full shift and 1 for part shifts)
- Color (use conditional logic like =IF(Status="Occupied", "Green", "Red"))
3. Insert a Bubble Chart:
- Use X and Y coordinates to position seats (you can arrange them in a grid manually)
- Use bubble size for shift (small/large)
- Use color logic with a custom VBA macro or conditional formatting via data labels (native Excel charts don’t directly support different colored bubbles with label text).
4. Enable auto-refresh using TODAY() in formulas — this ensures Column J checks stay updated.
Point no. 1 is already done, point no. 2 is done.
But point no. 3 and 4 goes above the head. Please help