The booking chart groups bars by week, but you want to compare the two weeks for each room. Switch the chart’s grouping while leaving the source values in place.

Check which labels are on the axis and in the legend

Use a sample table with Cedar and Birch counts for Week 1 and Week 2. Give Cedar six and eight bookings, and Birch five and seven. Select the editable chart in Ulet and choose Chart Design → Switch Row/Column. The room names should now appear on the category axis and weeks in the legend.

The source table supports comparison by week or by room.

Illustrated source data. Read the legend and category axis before switching.

Trace Cedar’s Week 2 value

In the Cedar group, find the Week 2 series and check that it shows eight. Update the chart title if it describes the old grouping. Save and reopen the workbook to confirm the axis, legend, and value.

Cedar’s Week 2 value of 8 appears in the Cedar group.

Illustrated switched chart. Verify a known value and the legend.

Microsoft’s reference for switching chart rows and columns