Little Pie Charts
I found a free font that displays pie charts: Pie Charts for Maps Font.
But it's not just for maps, of course. Here's an example of using this font in Excel:
The pie images are mapped to 22 alpha characters, from A through U. A is 0%, B is 5%, C is 10%, and so on. So, if you want to display a pie chart in a cell you need to convert the value to an alpha character. This formula, in cell E2, does the job:
=MID("ABCDEFGHIJKLMNOPQRSTU",INT(D2*20)+1,1)
This formula returns the "O" character, which corresponds to values from 70.0% through 74.9%
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.
All Topics
Filter by Category
Subscribe
Recent Comments
Other Blogs
2