Add the Year 2022 data series to the chart (using cells (B3:D7.
To add the Year 2022 data series to the chart using cells B3:D7, follow these steps:
1. Select the chart by clicking on it.
2. In the Excel ribbon, select the "Design" tab, which appears when you have the chart selected.
3. On the "Design" tab, click on the "Select Data" button in the "Data" group. This will open the "Select Data Source" dialog box.
4. In the "Select Data Source" dialog box, under "Legend Entries (Series)", click on the "Add" button. This will open the "Edit Series" dialog box.
5. In the "Edit Series" dialog box, in the "Series name" field, you can enter a name for the series, such as "2022".
6. In the "Series values" field, click on the little icon at the end of the field. This will open a small "Select Data Source" dialog box.
7. In the small "Select Data Source" dialog box, you need to select the range of cells B3:D7. Simply click in the field next to the "Range" label and then select cells B3:D7 in your worksheet.
8. After selecting the range of cells, click on the bottom-right corner of the small dialog box and drag it open so you can see the chart in the background.
9. Verify that the range displayed in the small dialog box is the correct range, B3:D7.
10. Click the "OK" button in the small dialog box to confirm the range.
11. Click the "OK" button in the "Edit Series" dialog box to confirm the new series and close the dialog box.
12. Click the "OK" button in the "Select Data Source" dialog box to close it.
Your chart should now include the Year 2022 data series, using the values from cells B3:D7.