How to Build Pie Charts in Google Sheets and Excel

Why Pie Charts Still Matter For Busy Teams

If you run a business, agency, or sales team, you live in spreadsheets. Revenue by product, leads by source, spend by channel – all of it usually lands in Excel or Google Sheets. A pie chart is often the simplest way to answer: what slice of the whole does each category own?

The problem is not making one pie chart. It is making the fiftieth this month, across different files, clients, and campaigns. That is where combining manual skills with AI agents gives you leverage.

Method 1: Manual Pie Charts in Excel (Step by Step)

1. Prepare your data

• Put category names in one column (for example, A2:A6: 'Email', 'Ads', 'SEO', etc.).
• Put numeric values in the next column (B2:B6: spend, revenue, or counts).
• Make sure there are no blanks or text in the value column.

2. Select the data

• Highlight A1:B6, including headers.
• Keep it to one data series; pie charts work best with a single row or column of numbers.

3. Insert the pie chart

• Go to the Insert tab.
• Click Insert Pie or Doughnut Chart.
• Choose a basic 2-D Pie to start.

Excel will immediately render a pie with each slice sized by the values in column B.

4. Format labels and percentages

• Click the chart, then the + icon (Chart Elements).
• Check Data Labels to show numbers.
• Right-click a label → Format Data Labels → enable Category Name and Percentage, and turn off raw values if you want a cleaner look.

5. Tidy colors and layout

• Use the paintbrush icon (Chart Styles) to apply a color palette that matches your brand.
• Drag a single slice outward to 'explode' it and draw attention to a key category.
• Resize and position the chart on your sheet or dashboard.

Pros (Manual Excel)

• Full control over design and fine details.
• Great for one-off analyses or small datasets.
• Easy to tweak on the fly in a meeting.

Cons (Manual Excel)

• Repetitive: you repeat the same clicks every week.
• Error-prone when copying formulas or ranges.
• Hard to scale across many files, clients, or teammates.

Method 2: Manual Pie Charts in Google Sheets

The flow in Google Sheets mirrors Excel, which is perfect when your team is remote or client data lives in Drive.

1. Structure your sheet

• Column A: categories (for example, campaign names).
• Column B: numeric values.
• Optional: use a separate summary sheet that references raw data with SUMIF or pivot tables.

2. Insert the chart

• Select the data range (for example, A1:B6).
• Click Insert → Chart.
• In the Chart Editor, change Chart type to Pie chart.

3. Customize for clarity

• Under Customize → Pie chart, turn on Slice label to show percentages or values.
• Use Slice settings to recolor key segments.
• If there are too many tiny slices, group small categories before charting so the pie stays readable.

Pros (Manual Sheets)

• Collaborative editing and commenting.
• Easy to embed in Docs, Slides, or shared dashboards.
• Works anywhere with a browser.

Cons (Manual Sheets)

• Still locked to human clicking and range selection.
• Tedious when you maintain many similar reports.

Method 3: Automate Pie Charts With an AI Computer Agent

Now imagine you never touch Insert → Pie again.

An AI computer agent running on a platform like Simular Pro can behave like a power assistant sitting at your keyboard:

• Open Excel or Google Sheets.
• Clean and aggregate data (for example, group dozens of survey responses into counts).
• Insert a pie chart with your preferred style.
• Save, export, or paste the chart into the right slide deck.

You define the workflow once – 'for every new weekly performance sheet, create three pie charts: revenue by channel, leads by source, and spend by campaign' – and the agent executes it across desktop, browser, and cloud.

Pros (AI Agent Automation)

• Massive time savings when you have recurring reports.
• Consistent formatting across clients and teams.
• Runs end-to-end: from raw CSV download to finished chart in a deck.
• Production-grade reliability when built on an agent platform designed for long, multi-step workflows.

Cons (AI Agent Automation)

• Requires some upfront setup: documenting steps and edge cases.
• Best suited to stable, repeatable workflows rather than one-off experiments.

When To Hand Pie Charts Off To An Agent

If you only build a chart once a month, keep it manual. But if you:

• Rebuild the same Excel or Sheets charts weekly,
• Maintain dashboards for multiple clients, or
• Have team members wasting hours on copy-paste and reformatting,

then it is time to let an AI agent handle the drudgery while you focus on interpreting what each slice of the pie is really telling you.