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.

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.

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



