Before you start

• Open {{code:02_survey_analysis}}. The guided build reads the {{code:sample_data}} sheet you made in lesson 7: Response, Class, Transport, Minutes, Cost_per_week, Would_cycle and Journey_rating in columns A to G.
• No {{code:sample_data}} sheet? Add one and paste the sample below at {{cell:A1}}.
• Your own data comes in the Portfolio Build, once the dashboard works on the sample.

Response	Class	Transport	Minutes	Cost_per_week	Would_cycle	Journey_rating
1	TY1	Bus	25	12	Maybe	3
2	TY1	Walk	10	0	No	4
3	TY1	Car	15	0	Yes	3
4	TY1	Bus	40	15	No	2
5	TY1	Cycle	12	0	Yes	5
6	TY1	Walk	8	0	No	5
7	TY1	Train	45	25	No	2
8	TY1	Car	20	0	Maybe	3
9	TY2	Bus	30	12	Yes	2
10	TY2	Walk	15	0	Maybe	4
11	TY2	Bus	35	15	No	2
12	TY2	Car	10	0	Yes	4
13	TY2	Cycle	18	0	Yes	4
14	TY2	Bus	20	10	Maybe	3
15	TY2	Car	25	0	No	3
16	TY2	Walk	5	0	No	5
17	TY3	Bus	50	15	No	1
18	TY3	Train	40	20	Maybe	2
19	TY3	Car	12	0	Yes	4
20	TY3	Walk	20	0	Maybe	3
21	TY3	Bus	28	12	Yes	3
22	TY3	Cycle	15	0	Yes	5
23	TY3	Car	30	0	Maybe	2
24	TY3	Bus	22	10	No	3

Layout to aim for on {{code:09_dashboard}}

• Title in {{cell:A1}}
• {{cell:A3}} Pick a transport, drop-down in {{cell:B3}}
• Large figures in row 5: Count, Avg minutes, Avg rating (change with the drop-down)
• Static total in {{cell:A7}} / {{cell:B7}}
• Helper table from {{cell:H1}} (Transport, Count, AvgMins, AvgRating)
• One chart under the headlines so the sheet fits without scrolling
• {{cell:A10}} says View-only link, with the share link pasted in {{cell:B10}}

Minimum for today: linked headlines, one chart, protect with B3 still working, view-only link in B10. A second chart is only if you still have time after that.