Chart for Library Student Occupency Chart

[MayAnk__Rathi]

I have study library of 70 seating capacity. All data is only in this sheet.

I want to create a chart in which I get libraray seat occupancy status by colour. Whenever seat is occupied then Green colour else Red colour. If a seat with Full shift, is displayed by large circle and if with Morning or Evening shift is displayed by small circle, and inside the circle seat number.

Status is automatically update when column J's date gone.

Below I attached the screenshot of chart which I want and my a small specimen of my data. Data is manually filled by me as and when student come and deposit fee. I want chart is update automatically as per data.

[v-menakakota · Accepted solution]

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 

[v-menakakota]

Hi @MayAnk__Rathi ,

Could you please confirm whether you have raised the same in Excel forum. May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you. 

[v-menakakota]

Hi  @MayAnk__Rathi ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you

[v-menakakota]

Hi  @MayAnk__Rathi ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily. 

 
Thank you. 

[danextian]

Hi @MayAnk__Rathi 

I don't think a visual for such as exist. This can be a good use-case for DAX-generated SVG images. Things missing: how are the circles split into columns and rows? By which dimensions? Also, please post a workable sample data, not an image. A link to an Excel file hosted in the cloud will do or the pbix itself. Who wants to  be manually typing the data in order to help someone for free?

[MayAnk__Rathi]

Student data is manually filled, but chart automatically change as per data.

1. Big circle means shift for full day
2. Small circle means shift of morining or evening time.
3. Circle automatically change shape as per shift.
4. In chart each row having fixed 10 seats.
5. 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.

[danextian]

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/1447... 

[MayAnk__Rathi]

Seat No.	Name	Shift	Date of Joining	Mode	Fee	Due	No. of Months	Date of Cesessation	Status
6	Anita	Full	25-05-2025	Bank	1000.00	0.00	1	25-06-2025	Occupied
24	Gajendra	Full	29-04-2025	Bank	1000.00	0.00	1	29-05-2025	Unoccupied
32	Parkash	Morning	16-05-2025	Cash	900.00	0.00	1	16-06-2025	Occupied
26	Puja Godara	Evening	01-05-2025	Cash	1000.00	0.00	1	01-06-2025	Unoccupied
32	Sangeeta	Evening	18-05-2025	Bank	900.00	9.00	3	18-08-2025	Occupied
7	Poonam Chand	Full	16-05-2025	Bank	1000.00	0.00	1	16-06-2025	Occupied
15	Mahendra	Full	16-05-2025	Bank	1000.00	0.00	1	16-06-2025	Occupied
10	Devendra Singh	Full	15-05-2025	Cash	1000.00	0.00	1	15-06-2025	Occupied
36	Devaram	Full	15-05-2025	Cash	900.00	0.00	3	15-08-2025	Occupied
12	Hakam	Full	07-05-2025	Bank	850.00	0.00	1	07-06-2025	Occupied
17	Mahendra	Full	04-05-2025	Cash	900.00	0.00	1	04-06-2025	Occupied
25	Kiran	Full	04-05-2025	Bank	1000.00	0.00	1	04-06-2025	Occupied
33	Surendra Singh	Full	03-05-2025	Bank	800.00	0.00	2	03-07-2025	Occupied
32	Manish Jangu	Full	16-02-2025	Bank	1000.00	0.00	1	16-03-2025	Unoccupied
60	Mayank	Full	01-05-2025	Cash	1100.00	500.00	1	01-06-2025	Unoccupied
16	Arvind Charan	Full	01-05-2025	Cash	1000.00	0.00	2	01-07-2025	Occupied
37	Renu	Morning	01-05-2025	Cash	500.00	0.00	2	01-07-2025	Occupied
4	ramkishor	Evening	29-04-2025	Bank	400.00	0.00	2	29-06-2025	Occupied
3	Suaa	Morning	28-04-2025	Cash	600.00	0.00	1	28-05-2025	Unoccupied
2	sumitra	Full	27-04-2025	Bank	2000.00	0.00	2	27-06-2025	Occupied
24	Vikash Bishnoi	Full	13-02-2025		1000.00	0.00	1	13-03-2025	Unoccupied

Is this possible to prepare and update automatically chart???