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.
