WEBVTT

00:00:00.000 --> 00:00:02.563
Here's how to turn raw café orders

00:00:02.563 --> 00:00:04.739
into a simple sales dashboard

00:00:04.739 --> 00:00:06.408
in Google Sheets.

00:00:07.000 --> 00:00:09.001
Line after line of orders shows

00:00:09.001 --> 00:00:11.512
very little until you summarize it.

00:00:12.100 --> 00:00:15.424
From the Insert menu, choose Pivot table

00:00:15.424 --> 00:00:18.185
and click Create. Then add Region

00:00:18.185 --> 00:00:21.220
as rows and Revenue as values.

00:00:22.400 --> 00:00:25.055
Open Insert again and add a chart.

00:00:25.055 --> 00:00:26.818
Google Sheets plots revenue

00:00:26.818 --> 00:00:29.312
for each region as a bar chart.

00:00:29.900 --> 00:00:32.320
Next, open the Data menu and add

00:00:32.320 --> 00:00:34.980
a slicer, set its column to Plan,

00:00:34.980 --> 00:00:37.748
then pick Growth plan to filter.

00:00:38.367 --> 00:00:39.989
The result: a pivot table

00:00:39.989 --> 00:00:42.198
and chart of revenue by region,

00:00:42.198 --> 00:00:44.679
with a slicer to focus the view.

00:00:45.267 --> 00:00:47.908
Try it with your own data: pivot,

00:00:47.908 --> 00:00:50.715
chart, and slice in Google Sheets.