Challenge $1-$ Pivot Table and Chart

Find a list of the Canadian provinces at Canadian Provinces by Population $2022($

worldpopulationreview.com$)$ and download the file listing the Canadian Provinces with population

as a CSV file.

Open Excel $-$ and get data CSV file.

Load to as a table to the worksheet. Insert a Pivot Table using the data from the imported table.

In the Pivot Table:

Rename Name to Province

Rename pop$2022$ to $2022$ Population

Rename pop$2016$ to $2016$ Population

Rename pop$2011$ to $2011$ Population

Rename growthRate $-$ Growth Rate

Format numbers as comma with no decimals, and any percentage to $\%.$

Add the correct fields that will show the population by province for $2016$ and $2022.$

Create a chart showing the two years.

Add any needed items to the chart, i$.$e$.-$ titles, axis titles, number formatting, etc. You can format this as you please, add any colours or chart effect you feel are necessary. Make sure it fits one page and can be read clearly.

Save your file and upload to Brightspace.