Publishing to web in Google Sheets - Dashboard Guide

Dashboard Mode - Publishing to web

Dashboard Goal

Show how to share a Google Sheets report online by publishing it to the web, so anyone with the link can view the data without needing access to the original file.

Sample Data

Month	Sales	Expenses
January	1000	400
February	1200	500
March	900	450
April	1100	480
May	1300	520

Dashboard Components

• KPI Card - Total Sales: Shows total sales for all months.
  Formula: =SUM(B2:B6)
  Result: 5500
• KPI Card - Total Expenses: Shows total expenses for all months.
  Formula: =SUM(C2:C6)
  Result: 2350
• Table - Monthly Profit: Calculates profit per month (Sales - Expenses).
  Formula in D2: =B2-C2 and drag down to D6.
  Results: January=600, February=700, March=450, April=620, May=780
• Line Chart - Sales and Expenses Over Months: Visualizes sales and expenses trends across months.
  Uses data from columns A, B, and C.
• Publish to Web Link: A clickable link that shares the published version of this sheet online for anyone to view.

Dashboard Layout

+----------------------+----------------------+
| Total Sales: 5500    | Total Expenses: 2350 |
+----------------------+----------------------+

+--------------------------------------------+
| Line Chart: Sales and Expenses Over Months |
| (Months on X-axis, Sales & Expenses lines) |
+--------------------------------------------+

+-----------------------------+
| Table: Monthly Profit        |
| Month | Profit               |
| Jan   | 600                  |
| Feb   | 700                  |
| Mar   | 450                  |
| Apr   | 620                  |
| May   | 780                  |
+-----------------------------+

+-----------------------------+
| Publish to Web Link          |
| (Click to open published URL)|
+-----------------------------+

Interactivity

The published web version provides a non-editable view of the sheet. Users can view all data and charts but cannot edit them.

Changes to the original Google Sheet are automatically reflected in the published version.

No filters or slicers are interactive in the published web view.

Self Check

If you update the sales data for March from 900 to 1000 in the original sheet, which components update in the published web view?

• Total Sales KPI updates to 5600.
• Monthly Profit for March updates to 550.
• Line Chart updates to show the new sales value for March.
• Total Expenses and other months remain the same.

Key Result

A Google Sheets dashboard showing sales and expenses KPIs, monthly profit table, and a line chart, with instructions on publishing the sheet to the web for easy sharing.