How to Edit Pie Chart in Excel

You’ve created a pie chart in Excel, but it looks a bit plain. The default colors aren't quite right for your brand, the labels are hard to read, and it doesn't do a great job of highlighting the most important piece of information. This guide will walk you through customizing every part of an Excel pie chart, transforming it from a generic graphic into a clear, professional, and insightful visualization.

First, Select Your Chart

Before you can edit anything, you need to tell Excel what you want to change. Simply click once anywhere on your pie chart. Once you do, you'll see two new tabs appear on the Ribbon at the top of the Excel window: Chart Design and Format.

• The Chart Design tab is for big-picture changes. This is where you'll find pre-made styles, color palettes, different layouts, and options to add, remove, or change the position of chart elements.
• The Format tab is for more granular control. It lets you change the specific fill color of a single slice, adjust the font of the title, add a border to the chart area, and much more.

We'll be using both of these tabs extensively. As a general rule, start with Chart Design for broad strokes and then move to Format for the fine details.

How to Change Pie Chart Colors and Styles

The most common and impactful edit is changing the colors. A well-chosen color scheme can make your chart easier to understand and align it with your company's branding.

Applying Pre-built Chart Styles

The quickest way to give your chart a makeover is to use one of Excel’s built-in styles. These are professional designs that apply colors, shadows, and outlines with a single click.

1. Select your pie chart.
2. Go to the Chart Design tab.
3. In the Chart Styles gallery, you'll see a row of different designs. Hover your mouse over each one to see a live preview.
4. Click on the style that works best for you.

This is a great starting point, but you'll likely want to customize the colors even further.

Changing the Overall Color Palette

If you like the style but not the colors, you can change the entire color scheme while keeping the style's formatting (like shadows and borders).

1. With your chart selected, go to the Chart Design tab.
2. Click the Change Colors button.
3. You’ll see a dropdown menu of different palettes, typically grouped into "Colorful" and "Monochromatic."
4. Hover over a palette to see a preview, and click to apply it to your chart.

This is perfect for quickly matching the chart to your presentation's or brand's color theme.

Changing the Color of a Single Slice

What if you want to make just one slice - for example, your best-selling product - stand out? You can easily change the color of individual slices.

1. Click once on the pie chart to select the entire series of data (all slices will be highlighted).
2. Click a second time on the specific slice you want to change. Now, only that single slice should be selected.
3. Right-click on the selected slice and choose Format Data Point... from the menu. This will open a formatting pane on the right side of your screen.
4. In the pane, click the paint bucket icon (Fill & Line).
5. Click on Fill to expand the options, choose Solid fill, and then select your desired color from the Color dropdown. You can also adjust transparency here if needed.

You can repeat this process for every slice to create a completely custom color scheme.

Adding and Customizing Data Labels

A pie chart is just a collection of colored shapes without labels to explain what they represent. Clear labels are essential for your audience to understand the data.

How to Add Data Labels

1. Select your pie chart.
2. Click the green plus sign (+) button that appears on the top-right corner of the chart. This is the Chart Elements menu.
3. Check the box next to Data Labels.

Labels (usually the numerical values) will instantly appear on your chart.

Fine-Tuning Your Data Labels

Just adding the labels is only half the battle. You need to format them for clarity.

1. Click the arrow next to Data Labels in the Chart Elements (+) menu and select More Options…. This will open the Format Data Labels pane on the right.
2. Under Label Options (the icon with three bars), you can choose what information to display in your labels:
3. Under the Label Position section, you can choose where the labels appear:

Pro Tip: To improve clarity, it's often best to display both the Category Name and the Percentage, and then remove the chart's legend entirely to save space.

Editing the Title and Legend

The chart title and legend are the finishing touches that give your chart context.

1. To edit the title: Simply click on the "Chart Title" text box on your chart and start typing your own descriptive title. You can then use the options on the Home tab to change the font, size, and color just like any other text.
2. To move or remove the legend: Click the Chart Elements (+) menu, hover over Legend, click the arrow, and choose where to place it (Top, Left, Bottom, Right). If your data labels are clear enough (e.g., you've included Category Names), you can simply uncheck the Legend box to remove it.

How to Emphasize Data by Exploding a Slice

Exploding, or pulling out a slice from the rest of the pie, is an excellent technique for drawing attention to a key piece of data.

1. Click once to select the entire pie chart.
2. Click a second time on the slice you want to emphasize.
3. Click and hold your mouse on that selected slice, then drag it slightly away from the center of the pie.

You can also adjust this more precisely. Right-click the slice, choose Format Data Point..., and in the pane that opens, use the Point Explosion slider to set the exact distance.

Advanced Customization and Formatting

Once you've mastered the basics, you can apply a few more advanced touches to make your chart even better.

Rotating the Pie Chart

Sometimes the divisions between slices land awkwardly. You can rotate the entire pie to get a better-looking layout.

1. Right-click on any slice and choose Format Data Series....
2. In the pane on the right, look for the Angle of first slice option.
3. You can either drag the slider or type in a degree of rotation. For example, entering 90 will rotate an upward-pointing slice to face right.

Changing the Chart Type to a Donut Chart

Donut charts are very similar to pie charts but are often considered a stronger visualization because they have a hole in the middle. This changes the focus from comparing the slice angles to comparing the length of the arcs, which is often easier for the human eye.

1. Select your pie chart.
2. Go to the Chart Design tab.
3. Click Change Chart Type.
4. In the dialog box that appears, select Pie from the left-hand menu, and then choose one of the donut chart styles on the right.

You can then customize the donut chart using all the same techniques described above.

Final Thoughts

Customizing a pie chart in Excel is all about knowing where to find the right controls. By using the Chart Design and Format tabs, and the detailed formatting panes for each chart element, you can move beyond the defaults and create a chart that is clear, professional, and perfectly suited to tell your data's story.

While mastering Excel is great, building reports across multiple platforms like Google Analytics, Shopify, and your CRM can still feel like a full-time job. At Graphed, we completely automate this process. We designed it so you can connect your marketing and sales data with a few clicks and then simply ask for the visuals you need in plain English - like "show me a pie chart of Shopify sales by product category for last month." We give you real-time, interactive dashboards without the hours of manual spreadsheet work.