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.

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

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.

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