In this lab, your task is to create charts to display revenue information. You'll need to create and modify both a chart and a PivotChart. Perform the following actions:

$1.$ On the Regions sheet, use the data in A$1$:C$9$to create a combo chart using clustered columns for revenue and a line for cost of goods sold, with both fields sharing the same axis.

$2.$ On the Alter Data sheet, modify the data selection to only use year $1$ and year $2.$

$3.$ From the Product Data sheet, create a PivotChart using default values, with Products as the rows, Regions as the columns, and Revenue in the Values field.

$4.$ On the Summary tab, apply the Color $4$ palette and the Style $3$ style to the chart.

You want to configure Excel to prevent automatic changes to formulas and the execution of macros. Perform the following actions:

$1.$ Configure Excel to recalculate formulas only when the workbook is saved or manually updated.

$2.$ Stop the execution of macros in Excel without notifications.