Question

In the Profit - Loss Summary worksheet, change the chart under Profit vs. Loss to select the data from cells B4:D6

Answer 1

To change the chart under Profit vs. Loss, select the data from cells B4:D6 in the Profit - Loss Summary worksheet by following the steps provided.

Step-by-step explanation:

To change the chart under Profit vs. Loss to select the data from cells B4:D6 in the Profit - Loss Summary worksheet, follow these steps:

1. Select the chart by clicking on it.
2. On the Design tab, click on the 'Select Data' button.
3. In the Select Data Source dialog box, click on the 'Edit' button next to the 'Chart Data Range' field.
4. In the Edit Series dialog box, select the range B4:D6 for both the 'Series values' and 'Category (X) axis labels' by manually typing it or using the mouse to select the cells.
5. Click 'OK' in all dialog boxes to apply the changes.