How to Make a Circle Chart in Google Sheets with AI

A circle chart is one of the quickest ways to show how different parts make up a whole, like how much each traffic source contributes to your website's sessions. And while making one in Google Sheets is straightforward, its built-in AI can instantly transform your raw data into a clear visual. This article will guide you through creating and customizing circle charts in Google Sheets, covering both the classic manual method and the faster AI-powered approach.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a Circle Chart?

A circle chart is a circular statistical graphic that's divided into slices to illustrate numerical proportion. When you hear "circle chart," people are usually talking about one of two types:

• Pie Charts: The classic "pizza slice" chart where each section represents a percentage of the total. They're universally recognized and great for communicating simple breakdowns.
• Doughnut Charts: A pie chart with the center cut out. This modern variation is often easier to read because it emphasizes the length of the arcs on the circumference rather than the area of the slices, which can sometimes be misleading. Plus, you can use the empty space in the middle to display a key metric, like the grand total.

When to Use a Circle Chart

Circle charts are specialists. They do one thing extremely well: showing parts of a whole. Use them when your goal is to display the composition or percentage distribution of your data. Think of it like this: if you can frame your question as "What percentage of the total does each category represent?" then a circle chart is probably a good fit.

Great examples include:

• Marketing: Website traffic broken down by source (Organic, Social, Direct, Referral).
• Sales: Revenue contribution by product category.
• Finance: Budget allocation by department.
• Surveys: Distribution of responses to a multiple-choice question.

When to Avoid a Circle Chart

Using a circle chart in the wrong situation can lead to confusion. Here’s when to choose a different chart type, like a bar or line chart:

• Too Many Categories: A pie chart with more than 5-7 slices becomes a cluttered mess. If you have many categories, a bar chart is much easier for your audience to read.
• Comparing Datasets: If you want to compare the percentage breakdowns of two different time periods (e.g., Q1 traffic sources vs. Q2 traffic sources), using two side-by-side circle charts is clumsy. A stacked bar chart would show this far more effectively.
• Showing Change Over Time: Never use a circle chart to display a trend. To show how a specific metric has changed from month to month, a line chart is the clear winner.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Get Your Data Ready

The foundation of any good chart is properly organized data. For a circle chart in Google Sheets, you need a simple two-column setup. Your data should appear in your sheet like this:

• Column A: Categories. These are the labels for each slice of your pie (e.g., "Organic Search," "Social Media," "Direct").
• Column B: Values. These are the numeric amounts corresponding to each category (e.g., the number of sessions from each traffic source).

For example, let's say you want to visualize your website's traffic sources for the month. Your data in Google Sheets would look like this:

+------------------+----------+ | Traffic Source | Sessions | +------------------+----------+ | Organic Search | 15,200 | | Direct | 8,150 | | Social Media | 6,500 | | Referral | 3,800 | | Paid Search | 2,100 | +------------------+----------+

Keep it clean and simple. Make sure you have clear headers, and your values are purely numeric. Don't add percentage signs or commas inside the cells with your numbers, use Google Sheets' formatting tools for that if needed.

Step 2: Create Your Circle Chart (The Classic Method)

Once your data is set up, creating the chart takes less than a minute. Here are the steps to do it manually.

1. Select Your Data

Click and drag your cursor to highlight the data you want to visualize, including the headers. In our example, you'd select cells A1 through B6.

2. Insert the Chart

With your data highlighted, navigate to the menu at the top of the screen and click Insert > Chart.

Google Sheets will automatically analyze your data and insert a recommended chart type. Because your data shows a simple composition, Sheets is smart enough to often default to a pie chart.

3. Choose Your Chart Type

If Google Sheets didn't select a circle chart, or if you'd prefer to use a doughnut chart instead, you can easily change it. With the chart selected, a "Chart editor" sidebar will appear on the right side of your screen. Look for the "Chart type" dropdown menu under the "Setup" tab. Click it and scroll down to the "Pie" section, where you can choose between a standard pie chart or a doughnut chart.

That's it! You now have a basic circle chart in your Google Sheet.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Customize Your Chart for Clarity and Impact

A default chart gets the job done, but a few simple customizations can make it significantly easier to understand and more professional-looking. In the "Chart editor" sidebar, switch to the "Customize" tab. Here are some of the most useful tweaks you can make.

Chart Style

This is where you can change the basics of your chart's appearance. Modify the background color, change the font, or make the chart borders more pronounced. A simple change like a light grey background can help your chart stand out on a busy spreadsheet.

Pie Chart Settings

This section offers the most powerful customization options for your chart itself.

• Doughnut hole: If you're using a doughnut chart, you can adjust the size of the hole. A value between 25% and 50% usually looks best.
• Slice label: This is a big one. By default, your chart might not show any values on the slices. You can choose to display the category name ("Label"), the specific numeric value ("Value"), the percentage of the whole ("Percentage"), or a combination. Displaying the percentage directly on the chart makes it much faster to read.
• Label font size & color: Once you add slice labels, make them readable! A 12-point font is usually clear, and using a bold white font often looks great against colorful slices.

Pie Slice Colors

Don't be shy about branding your charts. Click on "Pie Slice" to individually change the color of each segment. You can use your brand's colors or choose a high-contrast palette to make different categories pop.

Chart & Axis Titles

Your chart title is prime real estate. Replace the default "Sessions vs. Traffic Source" with something more descriptive and insightful, like "Q3 Traffic Breakdown: Organic Search Drives Over 50% of Sessions." It immediately tells your audience what they are looking at and what the main takeaway is.

"But What About AI?" Using 'Explore' to Instantly Create Your Sheet's Circle Chart

If the manual method feels like too many clicks, Google Sheets has a built-in AI assistant called "Explore" that can create charts for you based on natural language.

Here’s how to use it:

1. Select your data: Just as before, start by highlighting the cells containing your data (A1 through B6 in our example).
2. Open Explore: Look for the small, star-shaped icon in the bottom-right corner of your screen (it might be labeled "Explore" when you hover over it). Click it.
3. Review AI-Generated Answers: A new "Explore" sidebar will appear. This panel automatically analyzes your data and suggests insights and visualizations. Because our data is a breakdown of a whole, the AI will almost always suggest a pie chart right away under the "Answers" section.
4. Use Natural Language: You can also skip the suggestions and just ask a question. At the top of the Explore panel, there’s an input box that says "Ask a question about this data." Type in a simple prompt like:

The AI will process your request and generate the corresponding chart in seconds.

1. Insert the Chart: To add the AI-generated chart to your sheet, simply hover over it and click the "Insert chart" icon that appears, or drag and drop it directly onto your canvas.

The "Explore" tool is fantastic for quickly generating standard charts without having to navigate through menus. It acts as a great starting point, and you can always customize the chart further using the "Chart editor" after you insert it.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Limits of AI in Google Sheets

While the Explore feature is an excellent productivity booster, it comes with limitations. The AI's understanding is primarily confined to the data that exists on that single spreadsheet. It can’t connect dots from other data sources on its own.

For example, you can’t ask it to "create a pie chart comparing signups from HubSpot with sessions from Google Analytics" unless you first export both datasets and manually combine them into one Google Sheet. The data wrangling still falls on you. The AI in Google Sheets is there to visualize the data you've already prepared, not to prepare it for you.

Final Thoughts

You now know everything you need to confidently create circle charts in Google Sheets. You can choose the precise, manual method for full control or use the AI-powered 'Explore' feature to generate visuals in seconds. Both approaches will help you turn columns of raw numbers into a clear, compelling story about your business.

While Google Sheets is great for quick visualizations from a single file, the real bottleneck is often getting the data ready in the first place. Toggling between Google Analytics, Shopify, and your other platforms to download CSVs gets tedious fast. At Graphed, we solve this by letting you connect your data sources directly and build dashboards with natural language. Instead of wrangling spreadsheets, you can simply ask, "show me a dashboard of Shopify revenue vs. Facebook Ads spend for this month," and get a live, automated report in seconds, not hours.