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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920