Question

In the Annual Sales worksheet, insert a 2-D Clustered Column chart based on the data in cell range A5:E15. Include the column headings and position the chart below the table.

Answer 1

To create a 2-D Clustered Column chart in Excel, select the range of data and use the 'Insert' tab to choose the 'Clustered Column' chart option. Position the chart below the table.

Step-by-step explanation:

Steps to create a 2-D Clustered Column chart in Excel:

1. Select the range of data you want to include in the chart (A5:E15 in this case).
2. Go to the 'Insert' tab and click on the 'Column' chart button.
3. Choose the 'Clustered Column' chart option.
4. The chart will be inserted on the worksheet. Position it below the table by dragging and dropping it into the desired location.

Make sure to include the column headings in the range you select to include them in the chart.