Setting up your worksheet with formulas of reference
In this next task, you will showcase only the data you want to chart using formulas of reference to extract the top 3 countries' medal tallies from the dataset and show them in the dashboard.
この演習はコースの一部です
Google Sheetsで学ぶデータ可視化
演習の手順
- Create a formula of reference in cell
A1that shows the contents ofA1in theOlympicssheet. - Copy the calculation down and across the sheet to show all data for the first 3 ranked countries.
- Make sure column
Bis wide enough to see the entire country name.
