Create a stacked column chart on the "Column Charts" worksheet that presents the population detail and the composition of the population $($Metro versus Non Metro only$)$ for each region and the state.

Stack the Metro and Non Metro ranges as separate chart series.

Format the chart with the regions and grand total $($C$14$:L$14)$ as the horizontal axis labels of the chart.

Title the chart, "Population Composition" $($without the quotes$).$

Display a chart legend.

Place the chart in the designated area.