Use Google Spreadsheets as a Dashboard with Charts and Graphs

The dashboard makes it simple to organize data in the form of KPIs and gives the data a structure in the form of graphs, charts, and many other visual representations. Isn’t it an excellent feature of Google Sheets to create beautiful and simple-to-understand data in visual formats for all these similar features to turn a piece of data into charts and graphs? Let’s examine how to create a dashboard using simple data conversion in the form of charts and graphs.

We will carry out this procedure step by step.

1. Selecting a data collection

We collected sales information for the items mentioned from (A to H) on the sheet with the title Dashboard; the next step would be to create the dashboard.

2. The Dashboard Area

For the dashboard, we want a specific area, thus we must shift our data and create room at the top.

3. Inserting Graphs and Charts

We had to choose our data and then click the “insert” option to add graphs; within the insert option, we had to select “chart” to turn the data into a chart.

4. Editing the chart as necessary

You can see a chart that Sheets automatically created on screen 4; we also have a “chart editor” option that allows us to make changes to the chart.

5. Give the Dashboard a name and include other graphs.

To include graphs for another data set, we will repeat step 3. As you can see in screen 6, we named our dashboard “PRODUCT SALES DASHBOARD.” You can name your dashboard similarly.

6. Selecting a different type of chart

For the second set of data, we selected a “Pie chart” from the editor’s many available “chart type” options.

Similarly, we selected a line graph for the third data set (screen 7).

7. Final setup

Finally, you can see in Screen 8 how we created the final dashboard; it was a simple and enjoyable process.