a. Create a Clustered Column chart based on the nonadjacent ranges A22:B26 and G22:G26.
b. Enter Estimated Sales: July and December as the chart title.
c. Resize and reposition the chart so its upper-left corner is in cell A35 and its lower- right corner is in cell E49.
d. Change the chart layout to Layout 2 to display the data values above the bars instead of including a vertical axis.
a. To create a Clustered Column chart based on the nonadjacent ranges A22:B26 and G22:G26, follow these steps:
1. Select the data ranges A22:B26 and G22:G26 by holding down the Ctrl key and clicking on each range separately.
2. Go to the "Insert" tab on the ribbon.
3. Click on the "Column" chart type button in the "Charts" group.
4. Select the "Clustered Column" chart type.
b. To enter "Estimated Sales: July and December" as the chart title, follow these steps:
1. Click on the chart to select it.
2. Go to the "Chart Design" tab on the ribbon.
3. Click on the "Add Chart Element" button in the "Chart Layouts" group.
4. Click on "Chart Title" in the drop-down menu.
5. Select "Above Chart" from the sub-menu.
6. Enter "Estimated Sales: July and December" as the chart title in the placeholder that appears above the chart.
c. To resize and reposition the chart, follow these steps:
1. Click on the chart to select it.
2. Click and drag the handles on the edges of the chart to resize it as desired.
3. Click and drag the chart to move it to the desired position.
4. Release the mouse button when the upper-left corner of the chart is in cell A35 and the lower-right corner is in cell E49.
d. To change the chart layout to Layout 2, follow these steps:
1. Click on the chart to select it.
2. Go to the "Chart Design" tab on the ribbon.
3. Click on the "Quick Layout" button in the "Chart Layouts" group.
4. Select Layout 2 from the drop-down menu. The data values will now be displayed above the bars instead of including a vertical axis.