# How to build a sales dashboard in Google Sheets

Create a simple sales dashboard by summarizing your spreadsheet data with a pivot table, then adding a chart and slicer. Follow these steps in order to build the dashboard from your existing dataset.

## 1. Select all data

![Select all data](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-1.jpg)

Click the top-left corner cell area of the sheet to highlight the entire dataset. Make sure all rows and columns in your table are selected before you continue.

## 2. Open the Insert menu

![Open the Insert menu](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-2.jpg)

With the data still selected, click Insert in the top menu bar. This opens the options for adding something based on the selected data.

## 3. Choose Pivot table

![Choose Pivot table](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-3.jpg)

In the Insert menu, click Pivot table. This opens the pivot table setup dialog.

## 4. Create the pivot table

![Create the pivot table](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-4.jpg)

Leave New sheet selected, then click Create. Google Sheets adds a new sheet with a pivot table and opens the Pivot table editor.

## 5. Add a row field

![Add a row field](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-5.jpg)

In the Pivot table editor, click Add next to Rows. Choose the field you want to group by, such as Region.

## 6. Add a values field

![Add a values field](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-6.jpg)

Click Add next to Values in the Pivot table editor. Choose the metric you want to summarize, such as Revenue, so the pivot table shows totals by region.

## 7. Insert a chart

![Insert a chart](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-7.jpg)

Open Insert again from the top menu and add a chart based on the pivot table summary. A column chart is created from the pivot table data.

## 8. Add a slicer

![Add a slicer](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-8.jpg)

Open the Data menu and click Add a slicer. This inserts an interactive filter you can use with the dashboard.

## 9. Set the slicer column

![Set the slicer column](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-9.jpg)

In the side panel, choose Plan as the slicer column. This makes the slicer control filtering by plan type.

## 10. Filter the dashboard

![Filter the dashboard](https://turtlescenestore.blob.core.windows.net/screenshots/9186c5ca-b650-4617-a57c-65616cc3bb5d/demos/27840382-eedd-426d-a1a3-424d7ad2f37e/pack-1792659075362/article/step-10.jpg)

Open the slicer values and clear Growth plan to filter it out. The slicer, pivot table, and chart update together on the sheet.

Your dashboard is now set up, and you can keep adjusting the pivot table, chart, or slicer to explore your sales data.