How to Make a Circle Chart

Circle charts, like pie charts and donut charts, offer a simple and intuitive way to show how individual parts make up a whole. They're staples in business reports, dashboards, and presentations for a reason - they make proportional data easy to understand at a glance. This guide will walk you through exactly when to use them, when to avoid them, and how to create them step-by-step in common tools like Excel, Google Sheets, and Canva.

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 is a Circle Chart? A Quick Refresher

A circle chart is a circular statistical graphic that is divided into slices to illustrate numerical proportion. In essence, the entire circle represents 100% of something, and each slice represents a percentage of that total. It’s perfect for answering the question, "what is the share of each category?"

There are two main types you'll encounter:

• Pie Chart: This is the classic circle chart. The "pie" is the whole, and each "slice" represents a distinct category. The size of the slice is proportional to its value in the dataset.
• Donut Chart: A donut chart is essentially a pie chart with the center cut out, creating a "donut" shape. This modern variation is often favored because it can be less visually overwhelming and the center space can be used to display a key total, like total revenue or total users.

When to Use (and Not to Use) a Circle Chart

While circle charts are popular, they aren't right for every situation. Using them correctly is the key to clear and accurate data storytelling. Using them incorrectly can easily confuse or mislead your audience.

Use a Circle Chart When:

• You are showing parts of a whole: The golden rule. If your data doesn't add up to a meaningful total (100%), you should use a different chart, like a bar chart. Good examples include budget breakdowns, market share distribution, or survey results for a single-choice question.
• You have a small number of categories: Circle charts work best with 6 or fewer categories. Any more than that and the slices become too hard to distinguish, making the chart cluttered and difficult to read.
• The proportions are clearly different: They are most effective when the values for each category are distinct. If you have several slices that are very similar in size (e.g., 23%, 24%, 25%), it's tough for the human eye to tell the difference.

Avoid a Circle Chart When:

• You need to show changes over time: A circle chart shows a snapshot at a single point in time. To track performance over weeks, months, or years, a line chart or bar chart is a much better choice.
• You want to compare categories between different datasets: If you want to compare the budget breakdown of Q1 versus Q2, for example, placing two pie charts side-by-side is visually clumsy. A stacked or grouped bar chart would make the comparison much clearer.
• Your categories are numerous or have very similar values: As mentioned, don't try to cram 10 different slices into one pie. If categories are too close in value, a simple bar chart will show the subtle differences much more effectively because it's easier to compare bar lengths than slice areas.

How to Make a Circle Chart in Excel

Excel makes creating a pie or donut chart incredibly straightforward. Here’s how to do 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

Step 1: Prepare and Select Your Data

First, organize your data into two columns. The first column should contain your categories (e.g., "Marketing Channel") and the second should contain their corresponding numerical values (e.g., "Traffic").

For example:

• Organic Search | 5,500
• Direct | 3,200
• Paid Ads | 2,100
• Social Media | 1,800
• Email | 950

Next, click and drag your cursor to highlight all the cells containing your data, including the headers.

Step 2: Insert the Chart

With your data selected, navigate to the Insert tab on the Excel ribbon. In the Charts group, click on the icon that looks like a pie chart ("Insert Pie or Doughnut Chart").

Step 3: Choose Your Chart Type

A dropdown menu will appear with several options. You can choose from a standard 2-D Pie, a 3-D Pie, or a Doughnut chart. Generally, it's best to stick with 2-D charts, as 3-D effects can sometimes distort the visual perception of the slice sizes.

Select your preferred style, and Excel will instantly generate the chart on your worksheet.

Step 4: Customize Your Chart

Now you can refine your chart to make it clearer and more professional. When you click on the chart, two new tabs will appear on the ribbon: Chart Design and Format.

• Add Chart Elements: On the Chart Design tab, click "Add Chart Element." Here you can edit the Chart Title, adjust the Legend position, or, most importantly, add Data Labels.
• Add Percentages: After adding Data Labels, right-click on one of the labels on the chart and select "Format Data Labels." In the panel that appears, you can check the box for "Percentage" and uncheck "Value" to show proportions instead of raw numbers. You can also adjust the label position here ("Inside End," "Outside End," "Center," etc.).
• Change Colors: In the Chart Design tab, click "Change Colors" to quickly apply a new color palette that matches your brand or report style.

How to Make a Circle Chart in Google Sheets

The process in Google Sheets is quite similar to Excel and just as user-friendly.

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 1: Enter and Select Your Data

Just like in Excel, set up your data in two columns with headers for your categories and values. Highlight the entire data range you want to visualize.

Step 2: Insert the Chart

With the data selected, go to the Insert menu and click on Chart. Google Sheets often intelligently guesses the best chart type, so it may default to a pie chart for you. If it doesn't, no worries - you can easily change it in the next step.

Step 3: Choose Your Chart Type in the Chart Editor

When the chart appears, the Chart editor pane will open on the right side of your screen. If the chart isn't already a pie chart, click the dropdown menu under Chart type on the Setup tab, and scroll down to the "Pie" section. You can choose "Pie chart" or "Doughnut chart."

Step 4: Customize Your Chart's Look and Feel

Switch from the Setup tab to the Customize tab in the Chart editor. This is where you can fine-tune every aspect of your chart's appearance:

• Chart Style: Change the background color, font, or create a 3D effect (though again, 2D and donut charts are usually best for clarity).
• Pie Chart: Here, you can change the Doughnut hole size (if you chose a donut chart), add border colors to slices, and edit Slice Labels to show percentages, values, or both.
• Chart & axis titles: Add and format your main chart title.
• Legend: Choose the position of the legend (e.g., top, bottom, right). For fewer slices, you might even remove the legend by positioning slice labels thoughtfully.
• Series: Click here to change the color of individual slices to better match your brand or message.

How to Make a Circle Chart in Canva

Canva is a fantastic tool for creating beautiful charts for presentations, reports, and infographics when aesthetics are a top priority.

Step 1: Find the Charts Element

In your Canva design page, click on the Elements tab in the left-hand editor panel. In the search bar, type "chart" and hit enter. Scroll down to the Charts collection and select a pie chart or donut chart design to add to your canvas.

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 2: Enter Your Data

Once you add a chart, a new panel will appear to the left of your design. This is where you will input your data. Delete the placeholder data and enter your own categories and a single series of numeric values. The chart will update in real-time as you type.

Step 3: Customize for Design

Canva’s strength is design customization. After your data is in, select the chart and use the toolbar that appears at the top of the editor page.

• Colors: Click on the color swatches in the toolbar to change the color of each slice individually.
• Fonts and Labels: Change the text style, size, and color for your labels. Canva gives you much finer control over placement - you can click and drag labels wherever you want.
• Settings: Click on the Settings icon in the toolbar to toggle labels and percentages on or off.

Final Thoughts

Circle charts are an effective tool for showing proportions clearly and simply, but only when used in the right context with a small, clear dataset. Creating them manually in tools like Excel, Google Sheets, or Canva is a fundamental skill for anyone working with data. Whichever tool you use, the key is to prioritize clarity over complexity, ensuring your chart tells its story at a single glance.

While building charts this way is valuable, we know that the biggest bottleneck is often the process of gathering and preparing the data itself. We built Graphed to remove this friction by connecting directly to your marketing and sales platforms. You can simply ask questions in plain English - like "Show me a pie chart of our top traffic sources from Google Analytics this month" - and get a real-time, shareable dashboard instantly, saving you from the routine of downloading CSVs and building reports from scratch.