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.
