Forum Discussion

MayAnk__Rathi's avatar
MayAnk__Rathi
Helper I
1 year ago
Solved

Chart for Library Student Occupency Chart

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 co...
Tips and Tricks
  • v-menakakota's avatar
    v-menakakota
    1 year ago

    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 

     

MayAnk__Rathi's avatar
MayAnk__Rathi
Helper I
1 year ago

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.

  • MayAnk__Rathi's avatar
    MayAnk__Rathi
    Helper I
    1 year ago
    Seat No.NameShiftDate of JoiningModeFeeDueNo. of MonthsDate of CesessationStatus
    6AnitaFull25-05-2025Bank1000.000.00125-06-2025Occupied
    24GajendraFull29-04-2025Bank1000.000.00129-05-2025Unoccupied
    32ParkashMorning16-05-2025Cash900.000.00116-06-2025Occupied
    26Puja GodaraEvening01-05-2025Cash1000.000.00101-06-2025Unoccupied
    32SangeetaEvening18-05-2025Bank900.009.00318-08-2025Occupied
    7Poonam ChandFull16-05-2025Bank1000.000.00116-06-2025Occupied
    15MahendraFull16-05-2025Bank1000.000.00116-06-2025Occupied
    10Devendra SinghFull15-05-2025Cash1000.000.00115-06-2025Occupied
    36DevaramFull15-05-2025Cash900.000.00315-08-2025Occupied
    12HakamFull07-05-2025Bank850.000.00107-06-2025Occupied
    17MahendraFull04-05-2025Cash900.000.00104-06-2025Occupied
    25KiranFull04-05-2025Bank1000.000.00104-06-2025Occupied
    33Surendra SinghFull03-05-2025Bank800.000.00203-07-2025Occupied
    32Manish JanguFull16-02-2025Bank1000.000.00116-03-2025Unoccupied
    60MayankFull01-05-2025Cash1100.00500.00101-06-2025Unoccupied
    16Arvind CharanFull01-05-2025Cash1000.000.00201-07-2025Occupied
    37RenuMorning01-05-2025Cash500.000.00201-07-2025Occupied
    4ramkishorEvening29-04-2025Bank400.000.00229-06-2025Occupied
    3SuaaMorning28-04-2025Cash600.000.00128-05-2025Unoccupied
    2sumitraFull27-04-2025Bank2000.000.00227-06-2025Occupied
    24Vikash BishnoiFull13-02-2025 1000.000.00113-03-2025Unoccupied

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