Question

The SalesByMonth worksheet contains data that displays the total monthly sales in 2017 and the budgeted total amounts for each month. Create a thermometer chart that compares total monthly sales to the budgeted amounts for 2017. Display Budgeted Sales on top of Sales. Set the secondary axis to display the same values as the Y-axis. Add an appropriate chart title.

Answer 1

To create a thermometer chart comparing total monthly sales to the budgeted amounts for 2017 on the SalesByMonth worksheet, follow these steps: select the data range, insert a clustered column chart, change the budgeted sales series to a line chart, adjust the secondary vertical axis, and add a chart title.

Step-by-step explanation:

To create a thermometer chart comparing total monthly sales to the budgeted amounts for 2017 on the SalesByMonth worksheet, you can follow these steps:

1. Select the range of cells containing the month names and the sales data.
2. Go to the 'Insert' tab on the Excel ribbon, click on 'Recommended Charts', and choose 'All Charts'.
3. In the 'All Charts' dialog box, click on 'Column' from the left menu, and then choose the '2-D Clustered Column' chart type.
4. Click 'OK' to insert the chart into your worksheet.
5. Right-click on one of the data series bars in the chart, and select 'Change Series Chart Type'.
6. Choose the 'Line' chart type, and click 'OK' to apply it to the budgeted sales series.
7. Right-click on the secondary vertical axis (the one on the right side of the chart), and select 'Format Axis'.
8. In the 'Format Axis' pane, under the 'Axis Options' tab, choose 'Right' in the 'Axis Position' section.
9. Under the 'Number' category, choose 'Number' as the 'Category' and select '0' decimal places.
10. Click 'Close' to exit the 'Format Axis' pane.
11. Finally, add an appropriate chart title by clicking on the chart title area and typing the desired title.