How to Rotate a Donut Chart in Excel

Find yourself tilting your head just so you can properly read that all-important donut chart slice stuck at the bottom? Rotating a donut chart in Excel is one of those simple tricks that makes a huge difference in clarity and presentation. This article will show you exactly how to adjust the “Angle of first slice” setting to get your chart looking perfect.

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

Why Rotate a Donut Chart in the First Place?

Before we get into the "how," let's quickly touch on the "why." While it might seem like a minor cosmetic tweak, rotating your donut chart is a surprisingly powerful tool for data visualization. A standard donut chart shows the relationship of parts to a whole, but its default starting position isn't always the most effective.

Here’s why you might want to give your chart a spin:

• To Emphasize a Key Data Point: The most prominent position on a chart is typically the very top, at the 12 o'clock position. If your largest or most important segment (like "Top Performing Ad Campaign" or "Largest Revenue Source") is hidden at the bottom, rotating it to the top immediately draws the viewer's attention to what matters most.
• To Improve Readability: When slices land directly on a major axis (like horizontally or vertically), their labels can become cramped or overlap, making the chart difficult to read. A slight rotation can create better separation and give your data labels more room to breathe.
• For Aesthetic Consistency: If you're creating a dashboard with multiple pie or donut charts, you'll want them to be visually consistent. Rotating them all to have the same starting point - for instance, always having the largest slice start at the top - creates a much more professional and tidy appearance.
• For Better Grouping: Sometimes you have related categories you want to appear together. For example, if you have two positive metrics and two negative ones, you could rotate the chart to group all the "good" slices on the right side and the "bad" slices on the left for a quick visual comparison.

Ultimately, rotation gives you control over your data's narrative, guiding your audience's eye directly to the insights you want to highlight.

Quick Refresher: Creating a Basic Donut Chart in Excel

If you already have your donut chart made, you can skip ahead to the next section. But if you're starting from scratch or need a quick reminder, here’s how to create a simple donut chart in a few clicks.

Step 1: Get Your Data Ready

First, make sure your data is structured properly. For a donut chart, you'll want your data in two simple columns: one for the category labels and one for their corresponding values. Keeping it clean like this makes the chart creation process seamless.

For example, let's say you're visualizing a quarterly social media marketing budget:

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

Click and drag your cursor to highlight the entire data range, including both column headers and the data itself (e.g., cell A1 through B5).

Step 3: Insert the Chart

With your data selected, navigate to the Excel ribbon at the top of the screen. Go to the Insert tab. In the Charts group, find and click the "Insert Pie or Doughnut Chart" icon. From the dropdown menu that appears, select the Doughnut chart option.

Excel will instantly place a default donut chart onto your worksheet.

How to Rotate a Donut Chart in Excel: Step-by-Step

Now for the main event. You have your donut chart, but the "Facebook Ads" slice - your most important one - is sitting somewhere off to the side. Let's move it to the prime top-center position.

Step 1: Select the Data Series

First, you need to tell Excel you want to format the chart's data. To do this, simply click once anywhere on the colored ring of the donut chart. You'll know you've done it correctly when you see small selection handles appear around the entire ring, highlighting all of the slices at once.

Pro Tip: Be careful not to click a second time on a specific slice, as this will isolate just that one slice for formatting (which is useful for other things, like "exploding" a slice, but not for rotation).

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 2: Open the "Format Data Series" Pane

Once the entire data series is selected, you need to open the formatting options pane. Excel offers a few ways to do this, so you can use whichever is fastest for you:

• The Right-Click Method: Right-click on the selected donut chart ring. A context menu will pop up. Choose Format Data Series... from the bottom of the list.
• The Double-Click Method: Simply double-click on any part of the donut chart ring.
• The Keyboard Shortcut: With the chart series selected, press Ctrl+1 on Windows or Cmd+1 on a Mac.

Whichever method you choose, a formatting pane will slide open on the right side of your Excel window.

Step 3: Find the "Angle of first slice" Setting

In the "Format Data Series" pane, look for a section called Series Options. Its icon usually looks like a small bar chart. Under this section, you'll find two primary controls for your donut chart: "Angle of first slice" and "Doughnut Hole Size."

Step 4: Adjust the Angle

This is where the magic happens. The "Angle of first slice" option controls the starting point of your chart. It works in degrees, with 0° (the default) being the 12 o'clock position.

• To start making adjustments, you can either drag the slider left or right or type a specific degree value into the box. Dragging the slider is great for visually finding the rough position you want.
• Excel rotates the chart clockwise. For example:

As you adjust the angle, you'll see your chart update in real-time. Keep adjusting the value until your desired slice is positioned exactly where you want it. For instance, to get the second or third slice at the very top, you'll need to play around with the angle until it's centered perfectly.

Advanced Tips for Perfecting Your Donut Chart

Rotation is just the beginning. Combine it with these other features to create truly professional-looking charts.

Combining Rotation with an "Exploded" Slice

Want to draw even more attention to a specific piece of the pie? Combine rotation with an explosion.

1. First, rotate the chart so your target slice is in a prominent position (like the top right).
2. Next, click once on the entire donut to select all slices. Then, click a second time only on the slice you want to emphasize. Now only that one slice should have selection handles.
3. Go to the "Format Data Point" pane on the right (it looks similar to the "Data Series" pane) and find the "Point Explosion" slider.
4. Drag the slider to the right. This will pull the selected slice away from the center, creating a powerful visual highlight.

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

Adjusting the Doughnut Hole Size

Right below the angle adjustment, you'll find the "Doughnut Hole Size" slider. This control lets you change the thickness of the ring. A smaller percentage makes it look more like a traditional pie chart, while a larger percentage creates a thinner ring and more empty space in the middle. This empty space is perfect for our next tip.

Adding a Total or Key Metric in the Center

A very popular dashboard technique is to place a key metric, like the total value, inside the donut's hole. Here’s how to do it dynamically:

1. Use the "Doughnut Hole Size" slider to create enough empty space in the middle.
2. Go to the Insert tab > Text > Text Box.
3. Draw a text box inside the hole of your donut chart.
4. This is the key step: instead of typing directly into the text box, click on the border of the text box to select it.
5. Now, go to the Formula Bar at the top of Excel. Type an equals sign (=) and then click on the cell that contains the value you want to display (for example, the cell with a SUM() formula calculating the total budget).
6. Hit Enter. The value in your text box is now linked to that cell and will update automatically whenever your data changes. Use Excel's formatting options to center the text and adjust the font size.

Final Thoughts

Rotating a donut chart in Excel is a straightforward process handled directly in the "Format Data Series" pane. By simply adjusting the "Angle of first slice," you can easily move your data into the perfect position to emphasize key insights and improve clarity. This single tweak gives you narrative control over your data, ensuring your audience sees exactly what you want them to see.

As powerful as spreadsheets are, manually creating and refining charts can take time away from actual analysis. At Graphed, we automate the busywork of reporting. Instead of spending hours pulling data from platforms like Shopify or Google Ads and wrangling it in Excel, you can connect your data sources in seconds. Then, just ask in plain English: "Build a donut chart showing my marketing spend by channel for last quarter," and we instantly generate a live dashboard for you - no fiddling with angles or formatting required.