Excel - Creating a Pie Chart on a Coin in Excel | Unique Charting Tutorial - Episode 836

3,192 views · Published 8 January 2009 · 3:57 · Indexed 16 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Creating a Pie Chart on a Coin in Excel | Unique Charting Tutorial.

Welcome to another MrExcel netcast! In this video, we'll be tackling a unique question from the Southeast Accounting show: how to make a pie chart out of a coin. At first, it may seem like a simple task, but as we'll see, it's not as straightforward as it seems.

My initial approach was to select the coin and copy it to the clipboard, then insert a pie chart and use the coin as a picture fill. However, this resulted in the picture being squeezed into each slice of the pie, which is not the desired outcome. So, I'll show you a better approach that will give you a clean and professional-looking pie chart on a coin.

First, we'll build the pie chart without the coin. I'll insert a 2D pie chart and make a few adjustments, such as turning off the legend and adding data labels with the category name and percentage. Then, I'll make the pie chart and chart area transparent. This will create a blank chart that we can see through.

Next, I'll take the coin and place it behind the chart. This is where the real challenge begins, as we'll need to adjust the chart to line up perfectly with the coin. It may take a few minutes, but with some patience and tweaking, we can achieve a great result.

This method works in both Excel 2007 and 2003, with a slight difference in the process. In Excel 2007, we can easily format the chart and series without closing the dialog box, making it a bit easier. However, in Excel 2003, the transparency disappears as we move the chart, making it a bit more challenging. But with some practice, you can create a stunning pie chart on a coin in either version.

I hope you found this tutorial helpful and learned a new trick for creating unique charts in Excel. Don't forget to subscribe to our channel for more helpful tips and tricks, and we'll see you next time for another netcast from MrExcel. Thanks for watching!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


This was an intriguing question...how can you set up a pie chart in Excel that appears to divide a dollar coin into wedges?

It is not as easy as you would think. If you try to fill the chart with an image of a coin, Excel repeats the coin image on each wedge of the pie. Cool, but not what we are looking for.

Episode 836 will show you how to successfully get the coin as the background of the pie chart.

Table of Contents:
(00:00) Introduction
(00:17) Making a Pie Chart Out of a Coin
(00:28) Better Approach: Building the Chart First
(01:03) Adjusting the Chart to Fit the Coin
(01:34) Making the Chart Transparent
(02:31) Adding the Coin to the Chart
(02:41) Final Adjustments
(03:01) Removing the Border
(03:12) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adding data labels to Excel pie chart
Adjusting chart position in Excel
Creating a pie chart from an image in Excel
Creating a pie chart in Excel 2003
Creating a pie chart in Excel 2007
Excel pie chart with picture fill
Formatting chart border in Excel
How to format a pie chart in Excel
Making a pie chart out of a coin in Excel
Making a transparent pie chart in Excel
Removing legend from Excel pie chart
YouTube pie chart tutorial

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152023/

More from this channel