Forum Discussion
Chart for Library Student Occupency Chart
Hi MayAnk__Rathi ,
Thanks for reaching out to the Microsoft fabric community forum.
Excel’s Bubble Chart feature is well-suited for your needs, such as varying circle sizes by shift, using colors to represent occupancy status, and displaying seat numbers within the bubbles. For more specific guidance on implementing this in Excel, I recommend posting your question in an Excel-focused forum.
Welcome to the Excel Community | Microsoft Community Hub.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.Best Regards,
Menaka.
Community Support Team
Student data is manually filled, but chart automatically change as per data.
- Big circle means shift for full day
- Small circle means shift of morining or evening time.
- Circle automatically change shape as per shift.
- In chart each row having fixed 10 seats.
- Red circle denotes seat is vacant while green circle denotes occupied seat.
Here below I attach screenshot of sample data. In right side of screenshot, have attach a sample of chart which I want, if you change something change in chart then no issue.
Unable to send you copy of excel sheet.
Like I've mentioned, please don't make us manually type the data. There are mutliple ways to share it other than to paste a picture.
In chart each row having fixed 10 seats. But how do you know which seat goes to which circle, row?
Please refer to this post: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523