How to Build Pie Charts Fast in Google Sheets & Excel

The Real Problem With Pie Charts

If you’re a marketer, agency lead, or founder, you probably don’t mind crafting a single pie chart. It’s the tenth one—on the third client file—at 11:30 p.m. that hurts.

The steps are always the same: clean the data, select the range, click Insert, fix the labels, tweak the colors, export. Useful, but mind-numbingly repetitive. That’s exactly the type of work AI computer agents are built to take off your plate.

Below are the top ways to create pie charts in Excel and Google Sheets, from fully manual to fully automated with a Simular AI agent.

1. Manual: Create a Pie Chart in Excel (Step by Step)

Step 1: Prepare your data

• Put your categories in one column (e.g., A): Channel
• Put corresponding values in the next column (e.g., B): Revenue
• Avoid negative values and keep categories to ~5–7 for readability.

Step 2: Select your data

• Highlight the full range, e.g., A1:B6 (including headers).

Step 3: Insert the pie chart

• Go to Insert > Pie or Doughnut Chart.
• Choose Pie (2‑D pie is usually clearest).

Step 4: Add labels and percentages

• Click the chart.
• Use the + button (Chart Elements) on the right.
• Check Data Labels.
• Right‑click a label → Format Data Labels → turn on Category Name and Percentage, turn off Value if you want a clean view.

Step 5: Style your chart

• Use the paintbrush icon (Chart Styles) to pick a color scheme.
• Keep high‑contrast colors for slices, avoid 3‑D effects, and don’t explode too many slices.

Pros (Manual Excel)

• Full control over every choice.
• Great for one‑off reports.

Cons

• Painful to repeat across many sheets, tabs, or clients.
• Easy to mis‑select a range or forget to update when data changes.

2. Manual: Create a Pie Chart in Google Sheets

Step 1: Structure your data

• Column A: categories (e.g., Product)
• Column B: values (e.g., Units Sold)

Step 2: Insert the chart

• Select A1:B6.
• Click Insert > Chart.
• In the Chart Editor, under Setup, change Chart type to Pie chart.

Step 3: Customize labels and legend

• In Customize > Pie chart, you can:
  • Enable Slice label to show percentage or value.
  • Adjust slice colors.
  • Move the legend (top/right/bottom) to avoid overlap.

Pros (Manual Sheets)

• Extremely fast for simple data.
• Easy sharing and collaboration.

Cons

• Same repetitive steps for every new file.
• Inconsistent styling across teams and clients.

3. Semi‑Automated: Summarize Text Responses First

Often your raw data isn’t numeric yet—think survey answers like “Apple, Orange, Cherry”. Neither Excel nor Google Sheets can chart plain text directly.

Step 1: Convert text to counts

• In Excel, use =COUNTIF(range, "Apple") for each category, or build a PivotTable with the text column in Rows and Values (count of responses).
• In Google Sheets, use =COUNTIF(range, "Apple") or a Pivot table.

Step 2: Chart the aggregated table

• Once you have Category + Count, use the same insert‑pie steps as above.

This still leaves you doing a lot of repetitive formula work when categories change or new files arrive.

4. Fully Automated: Let a Simular AI Agent Build Your Pie Charts

Now imagine you never touch the Insert tab again.

Sai is a highly capable AI computer agent that can operate across your entire desktop—Excel, Google Sheets in the browser, downloads, exports, even email. You show it how you like your charts once; it can repeat that workflow thousands of times with production‑grade reliability.

A typical “pie chart agent” workflow might look like this:

1. Open the source
   • The agent opens a folder of Excel files or a Google Drive folder of Sheets.
2. Identify the right data
   • It scans each sheet for a specific pattern (e.g., Channel and Revenue headers) instead of relying on brittle cell references.
3. Create standardized pie charts
   • In Excel, it selects the range, goes to Insert > Pie, applies your preferred style, turns on category + percentage labels, and positions the chart in a consistent location.
   • In Google Sheets, it uses the Chart Editor to create a pie chart with the same color palette and label rules.
4. Export or embed
   • The agent saves charts as images into a shared folder, copies them into PowerPoint, or pastes them into a client‑ready Google Slides deck.
5. Log what it did (transparent execution)
   • Every click and keystroke is recorded as readable steps. You can review, tweak, and re‑run. No mysterious black box.

Pros (AI Agent With Simular)

• Handles thousands of charts across Excel and Google Sheets without burning your team’s time.
• Consistent formatting across clients, campaigns, and reporting periods.
• Transparent, inspectable workflows—easy to audit and improve.

Cons

• Requires an initial setup: you need to walk the agent through a “golden run” of your ideal process.
• Best payoff when you have recurring reporting or many files—not just a single chart.

5. When Should You Automate Pie Charts?

Use manual methods when:

• You’re experimenting with a new data structure.
• You only need one or two charts.

Reach for a Simular AI agent when:

• You build similar pie charts every week or month.
• Your team repeats the same formatting decisions in Excel and Google Sheets.
• You want to free analysts and account managers to focus on the story, not the clicks.

In other words: keep the strategic thinking human, and let the AI handle the repetitive motions of chart creation at scale.