With Sheetgo Dashboards you can centralize existing graphs from all the Google Sheets in a workflow. Presenting this data in an alternative setting enables you to concentrate on the information, making it easy to share and analyze.
Read What is a data dashboard? to learn more about the benefits of using a dashboard to show your data.
Sheetgo Dashboards let you create a visual summary of information in your workflow. You can also easily share and download the dashboards giving you control over how this data is distributed.
Creating a Dashboard
You can create a Dashboard in any Workflow that has at least one Google Sheets.
To create your dashboard, first open the Sheetgo app. Open the workflow you want to use as the base for your dashboard. On the sidebar, click the "+" icon and select New Dashboard.
Supported chart types
Dashboards support 8 chart types:
Line chart
Area chart
Column chart
Column chart (grouped columns)
Combo chart (line and columns)
Stacked column chart
Pie chart
Doughnut charts
Selecting charts
When you create a Dashboard, a dialog box will appear. On the left, you will find all the spreadsheets in the workflow. Selecting a spreadsheet will bring up all its charts.
Select the charts you will use by clicking on the checkbox at the top right corner of each card. You can select charts and graphs from different spreadsheets inside the same workflow. This lets you see an overview of the information dispersed across your spreadsheets.
Tip: If you can't find a chart, click the refresh button on the top right.
On the bottom left, you can check the number of selected charts and the number of spreadsheets they are from.
Click Create dashboard to finish the process.
If the spreadsheet doesn't have a chart, you will be prompted to create one. This will take you to your spreadsheet, where you can add a chart.
After that, your Dashboard will show all the selected charts.
Tips to create charts for Sheetgo Dashboards
Edit new charts to ensure both axis are labeled properly.
Abbreviate values over 100 million to 4 characters or less to ensure they are displayed correctly.
Keep x-axis labels under 5 characters to ensure they are displayed correctly.
Don’t use over 10 columns for graphs to ensure they are displayed correctly.
Customized min and max axis values will not be reflected on Sheetgo Dashboards. Instead, charts will be shown using default values.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.