Create a bar graph
Start a new sheet by clicking the icon to the right of the sheet you created.
Now, create a bar plot showing the countries with the 10 highest levels of CO2 emissions in 2023 (or the most recent year of data).
Hint: Take advantage of the filter option to filter both by year and by countries with the highest emissions. To filter by countries with the highest emissions in 2023, you will want to use the Top tab in the filtering window, and select the “By formula” option. Here’s a function that sums the annual emissions, but only for the 2023 emissions of each country:
SUM(IIF([Year (co-emissions-per-capita.csv)]=2023, [Annual CO₂ emissions (per capita)], 0))
Formula explanation
The IIF function assesses the logical expression Year = 2023 and returns the Annual emissions if true, and 0 if false. Then, the SUM function sums across all these values for each country. Because the values for all other emission years were 0, it only sums the 2023 emissions.Hint 2: explore how to sort the bars by right-clicking on the country variable and selecting “Sort…”
View suggested solution
1. Drag the Annual CO2 emissions (per capita) field into the Columns shelf and either the Entity or Country Name field into the Rows shelf.
2. Drag the Year field to the Filters shelf. To show data from 2023 only, enter 2023 to 2023 in the Range of Values tab. Click OK.
3. Drag either the Country Name or Entity field into the Filters shelf. To show the top 10 countries with the highest CO2 emissions, click the Top tab in the window that pops up, select By formula and type `SUM(IIF([Year (co-emissions-per-capita.csv)]=2023, [Annual CO₂ emissions (per capita)], 0))`. Click OK.
4. To sort the bars from highest to lowest, right-click on the Entity (or Country Name) field in the Rows shelf, and click on "Sort...". Select "Field" under Sort By, choosing "Descending" in Sort Order, and Annual CO2 emissions in the Field Name. Then, exit the pop-up window by clicking on the X in the top right.
5. Name the graph "Countries with the highest CO2 emissions in 2023".
