Question

Remove the San Diego data series (range I7:L7) from the clustered column chart.

Answer 1

To remove the San Diego data series from the clustered column chart, follow these steps: 1. Select the chart and activate the Chart Tools tab. 2. Click on 'Chart Elements' and choose 'Legend'. 3. Uncheck the box next to 'San Diego'.

Step-by-step explanation:

To remove the San Diego data series (range I7:L7) from the clustered column chart, follow these steps:

1. Select the chart to activate the Chart Tools tab in the Ribbon.
2. Click on the 'Chart Elements' button and then choose 'Legend'.
3. In the drop-down menu, uncheck the box next to 'San Diego' to remove it from the chart.