SubscribeCreate in-cell pie charts in Excel
Posted on May 7th, 2008 in Charts and Graphs , Learn Excel , hacks , ideas , technology - 18 comments
Here is a ridiculously easy trick to do nice incell pie charts in excel, what more, they will make you look like a charting wizard.
- Download free pie chart font from here (direct download link). The font has 21 pie chart codes starting with empty circle (character ‘a’) and ending with full circle (character ‘u’)
- Install the font (just extract the zip file, copy the font file to your fonts folder, click here to learn how to install a font in windows)
- Open excel, go to your data table and insert a column where you want incell pie charts
- Enter a formula like
=CHAR(CODE("a") + ROUND(data cell*21,1)), just replace the data cell with actual cell code. - Finally change the font to “pie charts for maps” from font dialog.
- There is no step 6, so go ahead and show off this cool table to your colleagues, make their jaws drop in awe.
You can add some conditional formatting to the pie charts like I did to make it nice.
Feel free to download the sample excel I have prepared to know how to do in-cell pie charts
|
|
Posts & Navigation Tags: charts, Charts and Graphs, cool, fonts, how to, ideas, in-cell charting, Learn Excel, microsoft, MS, technology, tips, tricks |
Trackbacks & Pingbacks
- Pingback by Creating in-cell bar charts / histograms in excel | Pointy Haired Dilbert - Chandoo.org on May 13, 2008 @ 3:11 pm
- Pingback by Thermometer charts in excel - cool visualization trick | Pointy Haired Dilbert - Chandoo.org on June 26, 2008 @ 3:19 pm
- Pingback by Partition Charts in Excel - alternative to pie charts [visualization hack] | Pointy Haired Dilbert - Chandoo.org on July 9, 2008 @ 5:50 pm
- Pingback by Making Pie-charts look Sexy - The CNN’s tax burden analysis chart | Pointy Haired Dilbert - Chandoo.org on October 29, 2008 @ 1:47 pm
- Pingback by What is the best micro charting tool for Excel? - 7 Alternatives Reviewed | All Time Hits | Pointy Haired Dilbert: Charting & Excel Tips - Chandoo.org on May 30, 2009 @ 2:09 pm
- Pingback by 50 Best Cities for Finding a Job [Incell Dashboard using Excel] | Pointy Haired Dilbert: Charting & Excel Tips - Chandoo.org on August 20, 2009 @ 5:04 pm
- Pingback by Create Excel Dot Plots (in-cell) - Tutorial and Downloadable Template | Pointy Haired Dilbert: Charting & Excel Tips - Chandoo.org on December 5, 2009 @ 6:44 pm
Comments
RSS feed for comments on this post. TrackBack URI
Leave a comment
If you have a question, please ask in the forums
At Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. 
The conditional formatting part comes as the icing on the cake… Great tip, thanks.
Bhars
The in cell pie charts concept is not clear to me……the process is not self explanatory..i tried to understand the excel sheet u prepared but failed….i should not learn these concepts while talking to my girlfriend over phone…
Akash
@Bhars … you are welcome…
@Akash … Welcome to PHD. Can you tell me if you can understand this while you are not talking with your girlfriend..
, just kidding.. if you have any doubts feel free to ask… I may know how to answer them 
Great post ! Thanks for that.
Regards,
John
@John… you are welcome
Chandoo, thanks for a wonderful pie charts in a cell trick. If I have a pie chart font which has all the pie from 1% to 100% then do I need to change the formula?
Rgds
Champak
@Champak … thanks for the comments & welcome to PHD…
Oh yeah, just make sure the formula returns a character code that you can map to your pie chart font.. btw, can you let me know if you come across such font… I may post another tutorial using that font..
Chandoo,
i follow the instructions above, but i getting seven different pies in each cell. what am i doing wrong?
Thanks,
FYI the formula works better when you multiply by 20 instead of 21.
I am having trouble installing the pie chart font on a Mac G4. It won’t pass the verification step. Do you have another link or different copy?
@Ethoros: Thanks for the tweak…
@Bernie: I am not aware of any other fonts like this. Also, may be there is a limitation on TTFs in Mac (no idea what I am talking about..
) Can you google for some more fonts and let us know if you find an interesting option that works for Macs as well?