Inserting the VLOOKUP
We want to create a histogram to show the distribution of volumes. You will need to start by getting the
Volume data you want to show on the dashboard.이 연습은 강의의 일부입니다
Google Sheets로 배우는 데이터 시각화
연습 안내
- In
F16, type in the heading "Volume". - In
F17, enter a formula that usesVLOOKUPto look at the date in columnAand returns theVolumefor that date from theASXTable. - Copy the calculation down the column from
F17toF26.
