How to Make a Percentage Chart in Excel

Turning a table of numbers into a clear, compelling percentage chart is one of the fastest ways to show how different parts contribute to a whole. Instead of making your audience do the math, a good chart does the work for them, instantly highlighting key takeaways. This guide will walk you through a few different ways to create percentage charts in Excel, from the classic pie chart to more advanced visuals for your dashboards.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

First, Let's Get Your Data Ready

Before you can make any chart, your data needs to be structured correctly. For percentage charts, you generally start with a list of categories and the raw values associated with them, not the percentages themselves. Excel will do the percentage calculation for the chart, or we can add a helper column to do it manually.

Let's use a common example: website traffic from different marketing channels for a month. Your data in Excel might look like this:

Step 1: Set up your categories and values.

In one column, list your categories (e.g., "Organic Search," "Paid Social"). In the next column, put the corresponding numerical value (e.g., the number of sessions).

Step 2 (Optional but Recommended): Calculate the percentages manually.

While some charts can create percentages automatically, calculating them yourself gives you more control and helps you double-check the results. To do this, you'll need the total of all your values.

• First, find the total. In our example, you could click cell B7 and use the formula =SUM(B2:B6).
• Next, create a new column called "Percentage." In cell C2, divide the value for the first category by the total. The key here is to use an absolute reference for the total cell (using dollar signs, like $B$7) so that it doesn't change when you drag the formula down.

The formula for cell C2 would be:

=B2/$B$7

Drag the little square at the bottom-right corner of cell C2 down to C6 to apply the formula to the rest of your categories. Finally, select cells C2 through C6, go to the Home tab, and click the percent sign (%) in the Number group to format the cells as percentages.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Method 1: Create a Classic Pie Chart

A pie chart is the go-to choice for showing parts of a whole. Each slice represents a category's percentage contribution to the total. It’s perfect when you have a handful of categories and want to make a simple, direct comparison.

Step 1: Select Your Data

Click and drag to highlight your categories and their corresponding percentage values. In our example, you would highlight cells A2:A6 and C2:C6. To select non-adjacent columns, highlight the first range (A2:A6), then hold down the Ctrl key (or Cmd on Mac) and highlight the second range (C2:C6).

Step 2: Insert the Pie Chart

With your data selected, navigate to the Insert tab on the Excel ribbon. In the Charts section, click the pie chart icon and choose the visual you prefer. A simple 2-D Pie is usually the clearest and most professional option.

Step 3: Customize Your Chart for Clarity

Excel will instantly generate a basic chart, but it needs a few tweaks to be truly effective.

• Add a Title: Click on the default "Chart Title" and give it a descriptive name, like "Website Traffic by Channel."
• Add Data Labels: The chart isn't very helpful without the percentages on it. Right-click on any slice of the pie and select "Add Data Labels." By default, it might add the numerical value, not the percentage.

Pro Tip: Pie charts become cluttered and hard to read with more than 5-7 categories. If you have many small categories, consider grouping them into an "Other" category to keep your visual clean.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Method 2: Use a Donut Chart for a Modern Look

A donut chart is functionally the same as a pie chart, but its hollow center gives it a more modern feel and provides a clever space to add extra information, like the total number.

The creation process is nearly identical to the pie chart.

Step 1: Select Your Data and Insert the Chart

Just like before, select your categories and their percentage values (A2:A6 and C2:C6). Go to the Insert tab, click the pie chart icon, and this time, select Doughnut from the options.

Step 2: Format and Customize

Follow the same customization steps as the pie chart: give it a good title and add data labels formatted to show percentages and category names.

Here's the bonus trick for donut charts:

• Click on the Insert tab again, select Text Box, and draw a text box in the center of the donut hole.
• Instead of typing directly into the text box, click on the formula bar, type the equals sign (=), and then click the cell that contains your total traffic (cell B7). Press Enter.
• Now, the total traffic appears in the middle of the chart and will automatically update if your data changes. This creates a really professional-looking "total" summary right inside your visualization.

Method 3: A 100% Stacked Bar or Column Chart

What if you want to compare the percentage breakdown across different periods, like months or quarters? A pie chart can only show one period at a time. This is where a 100% stacked bar chart shines. It makes it easy to see how the proportional mix of your categories changes over time.

For this chart, you should organize your data with categories in the first column and different time periods or groups in the subsequent columns. Your data should contain the raw values, not percentages, as this chart type calculates percentages automatically.

Step 1: Select Your Data Range

Highlight the entire data range, including the headers and row labels (cell A1:D6 in our example).

Step 2: Insert the Chart

Go to the Insert tab, click the Column/Bar chart icon, and choose either the 100% Stacked Column (vertical) or 100% Stacked Bar (horizontal) option. The horizontal bar chart is often easier to read if you have long category names.

Step 3: Refine and Analyze

Excel will create a chart where each bar adds up to 100%. The differently colored segments represent the percentage contribution of each marketing channel for that month.

• Add a chart title as you did before.
• Right-click on any of the colored segments and select "Add Data Labels" to display the percentages within each segment.
• This view instantly tells a story. For instance, you can quickly see if the percentage of traffic from "Paid Search" is growing from January to March, while "Organic Search" is shrinking. This kind of comparative insight is impossible with a simple pie chart.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Method 4: The Advanced Progress Donut Chart (Gauge)

For dashboard reporting, you might want to show progress towards a goal, like hitting 75% of a sales target. A progress donut, or gauge chart, is a fantastic way to visualize a single percentage.

This method requires a bit of clever formatting.

Step 1: Set Up the Data

You need two values: the percentage complete and the percentage remaining. For example, if your progress is 75%, the remaining is 25% (or 1 - 0.75). Set it up like this:

Step 2: Create a Basic Donut Chart

Select those two values and their labels, and insert a regular Donut chart just as we did before. You'll get a chart split into two colors.

Step 3: Format the Chart into a Gauge

This is where the magic happens:

1. Rotate the Chart: Right-click on a chart segment and select Format Data Series. In the options pane, change the "Angle of first slice" to 270 degrees. This rotates the chart so the dividing line is at the bottom.
2. Make the "Remaining" Slice Invisible: Click once on the "Remaining" slice (the larger one, typically orange) to select just that slice. Go to the Format tab or use the right-hand pane and set the "Fill" to "No Fill." The slice is still there, but now it's transparent. The "Progress" slice (blue) now looks like a progress arc.
3. Add the Percentage in the Middle: Just like with our other donut chart, insert a text box in the middle. Click the formula bar, type =, click the cell with your percentage (A2), and press Enter. Format the text to be a large, bold font.

What you're left with is a professional-looking gauge that dynamically updates whenever your main percentage value changes.

Final Thoughts

Choosing the right percentage chart in Excel comes down to what story you want to tell. Whether you opt for a simple pie chart to show composition, a stacked bar chart to compare changes over time, or a gauge chart for a key performance indicator, mastering these basics will make your reports significantly more impactful.

Manually refreshing these Excel charts is manageable, but when your data lives across Google Analytics, Shopify, Salesforce, and other platforms, this process can turn into a tedious weekly ritual. At Graphed, we've automated this completely. You connect your data sources once, and instead of hunting for API keys or exporting CSVs, you can simply ask for "a line chart of our revenue by month" or "a pie chart of sales by rep this quarter." You get a real-time, interactive dashboard made for you in seconds. You can give Graphed a try and turn reporting hours into reporting seconds.