How to Update Pie Charts from Google Sheets and Slides

1. Manual ways to edit pie charts in Google Slides

If you only update a few charts occasionally, the built‑in workflow is enough. Here’s the end‑to‑end, traditional approach.

‍

Method 1: Edit a pie chart already embedded in Slides

1. Open your presentation in Google Slides.
2. Click the pie chart you want to change. A blue outline appears.
3. Click the dropdown in the top‑right of the chart and choose “Open source” (or “Edit chart” if prompted). This opens the linked Google Sheets file.
4. In Google Sheets, update the data that drives your chart:
   • Change labels in the first column (e.g., “Email”, “Paid Social”).
   • Change values in the second column (e.g., clicks, revenue, % share).
   • Add or delete rows to add/remove slices.
5. Close Sheets or switch back to Slides. If a yellow “Update” button appears on the chart, click it to sync the latest data.

For more detail on how pie chart data should be formatted, see Google’s help article on pie charts in Sheets: https://support.google.com/docs/answer/9143036

‍

Method 2: Create a new pie chart from scratch

1. In Google Slides, go to the slide where you want the chart.
2. Click Insert → Chart → Pie.
3. Slides inserts a sample pie chart linked to a new Google Sheets file.
4. Click the chart → click the dropdown → Open source.
5. In Google Sheets, replace the sample data with your own. Keep column 1 as labels, column 2 as positive numeric values.
6. Return to Slides and click Update if needed.

You can review Google’s general chart editing docs here: https://support.google.com/docs/answer/63824

‍

Method 3: Customize colors, labels, and style in Sheets

1. In the linked Google Sheets file, double‑click the pie chart.
2. The Chart editor panel opens on the right.
3. In the Customize tab you can:
   • Chart & axis titles: Rename the chart to match your story.
   • Pie slice: Change individual slice colors, or “explode” a key slice.
   • Legend: Adjust legend position and text style.
   • Pie chart: Add a doughnut hole or tweak slice borders.
4. Changes apply to the chart in Sheets; switch back to Slides and hit Update.

Official reference: https://support.google.com/docs/answer/63824 and the pie‑chart section at https://support.google.com/docs/answer/9143036

‍

Method 4: Import an existing pie chart from Google Sheets If your team already maintains dashboards in Sheets, reuse them.

1. In Google Slides, go to Insert → Chart → From Sheets.
2. Choose the spreadsheet with your pie chart.
3. Select the specific pie chart thumbnail.
4. Ensure “Link to spreadsheet” is checked.
5. Click Import. Now, every time you update that chart in Sheets, you can refresh it in Slides with the Update button.

Google’s Slides training hub (which covers linked content) is here: https://support.google.com/docs/topic/9054603

Pros of manual methods

• No extra tools or setup.
• Full control over every visual detail.
• Great for small teams and one‑off decks.

Cons

• Repetitive for recurring reports.
• Easy to miss a chart when data changes.
• Non‑scalable when you have dozens of campaigns or clients.

‍

2. No‑code automation with spreadsheet tools

Once you’re maintaining multiple reports, you want Google Sheets filling itself—and your pie charts following automatically.

No‑code Workflow 1: Auto‑refresh pie charts with live data in Sheets Use a connector like Coefficient or a similar no‑code data loader:

1. Install the add‑on in Google Sheets.
2. Connect it to your CRM, ad platforms, or analytics tools.
3. Configure a query that pulls the exact fields your pie chart needs (e.g., spend by channel, leads by source).
4. Map that query directly into the data range your pie chart uses.
5. Set an automatic refresh schedule (hourly/daily/weekly).
6. In Slides, your linked chart just needs an Update click before presenting—or you can let an AI agent handle that later.

Pros

• Eliminates CSV exports and copy‑paste.
• Keeps the underlying chart data accurate.
• Non‑technical marketers and sales leaders can operate it.

Cons

• Still requires you (or someone) to open Slides and refresh charts.
• Complex transformations can get hard to manage in formulas.

No‑code Workflow 2: Template‑driven reporting Agencies and revenue teams can standardize:

1. Build a master Google Sheets template with all your pie charts (one tab per report).
2. Build a matching Slides template where each chart is linked to a specific tab.
3. For each new client/campaign, duplicate the Sheets file and connect its data source.
4. Duplicate the Slides deck and relink charts from Insert → Chart → From Sheets.

Now a single data refresh populates all client decks. You still gain more leverage by having automation (or an AI agent) handle the refresh ritual.

‍

3. Scaling with an AI agent (Simular) across Sheets & Slides

At some point, the bottleneck isn’t data ingestion—it’s the human time spent babysitting charts. This is where a production‑grade AI computer agent like Sai becomes your reporting assistant.

‍

AI Method 1: Agent‑driven weekly reporting loop

Imagine your Monday standup deck always needs fresh channel spend and MQL split.

A Simular AI agent can:

1. Open your CRM and ad platforms in the browser.
2. Export or scrape updated metrics.
3. Paste or upload them into the correct Google Sheets ranges feeding your pie charts.
4. Open the right Google Slides deck.
5. Locate each linked pie chart, click Update, and verify visuals match expected ranges.
6. Save, export to PDF, and drop it into Slack or email for the team.

Pros

• End‑to‑end, cross‑app automation—desktop, browser, Sheets, and Slides.
• Transparent execution: you can see every step and tweak it.
• Ideal for agencies or sales teams running dozens of similar decks.

Cons

• Requires an initial setup of tasks and guardrails.
• Best suited when you have recurring, standardized reporting.

‍

AI Method 2: QA and formatting guardian for charts

Beyond just updating numbers, you can task the agent with quality checks:

1. After data refresh, have the agent scan Slides to confirm:
   • All pies use your brand palette.
   • Labels are visible and non‑overlapping.
   • No slice shows as 0% where business rules forbid it.
2. If a chart fails a rule (e.g., a tiny slice that shouldn’t exist), the agent:
   • Adjusts thresholds or groups minor categories into “Other” in Sheets.
   • Re‑updates the chart in Slides.
   • Logs what it changed in a summary doc or sheet.

Pros

• Raises the quality bar on every recurring deck.
• Frees humans to focus on insights, not pixel‑pushing.

Cons

• You need to define clear rules and exceptions.

‍

AI Method 3: Multiclient scaling for agencies

For agencies managing 20+ clients:

• A single Sai workflow can iterate through a client list, open each client’s Google Sheets report, refresh data, then open their Google Slides deck and update pie charts.
• With webhooks, you can trigger this run after data pipelines finish or before a known reporting deadline.

When you pair Google Sheets’ robust charting (see https://support.google.com/docs/answer/190718 for chart types) with Google Slides’ presentation power, an AI computer agent becomes the glue that turns a tedious reporting chore into an invisible background system.