An additional video on how to construct a PIVOT Table in Excel then show the values as a percent of either the Row or Column Total. I go over the interpretation of these and the differences based on if you are using Row or Column. I briefly provide an example of how to insert a Chart based on the Pivot Table with a secondary axis.
Data: data.littlerock.gov