How to Create An In-Cell Pie Chart in Excel

Excel In-cell Pie Chart Template – Free Download

In-cell pie charts are a series of mini circle graphs built inside worksheet cells. 

They are a great way to visualize your data without resorting to any default Excel charts, allowing you to analyze massive volumes of data quickly. This chart type is best suited to demonstrate progress toward a goal.

As an example, here’s how in-cell pie charts provide a bit more context around the actual data in column B:

How to create an in-cell pie chart in excel free template

And today, you will learn how to do the same thing.

Sample Data

To walk you through the process step-by-step, we’re going to build out our mini charts based on this table demonstrating the progress of developing a fictitious web application:

In-cell pie charts data table

The structure of the table is pretty straightforward, so let’s jump straight into action.

Step 1. Download and Install a Custom Pie Chart Font

To make it possible to build those small in-cell charts right in your worksheet cells, you need to install a custom font developed by Curtis Clark that allows converting percentage values into respective in-cell pie charts.

Head over to FontSpace and hit the “Download” button as shown on the screenshot below.

Download the custom font

Once there, extract the files from the ZIP archive, and install the font by following these simple instructions:

  1. Right-click on the file named “PieChartsForMaps-8ORB.tff” to open a contextual menu.
  2. Choose “Install for all users.
Install the custom font

Step 2. Map out the Chart Data

Once the font has been installed, go back to your Excel worksheet, and create a separate column right next to your actual data table – column Progress (Pie Chart) – where your mini charts will be stored. 

Then, enter the following formula into C2:

=CHAR(CODE("a") + ROUND(B2*21,1))

The formula picks the actual percentage values from column Progress (column B) and converts them into corresponding custom values that can be accurately matched with one of the pre-drawn in-cell circle charts.

Don’t forget to apply the formula to the rest of the column (C3:C9) by dragging down the fill handle.

Apply a custom formula

Step 3. Turn the Custom Values into In-cell Pie Charts

Finally, your last step is to convert the custom text values into the actual circle charts.

  1. Highlight all of the values in column C (C2:C9).
  2. In the Font group, select the “Font” dropdown menu, type “Pie charts for maps,” and press the Enter key.
Apply the custom formula

And that’s how you do it! Additionally, since Excel treats these mini charts as regular text values, tweak the font size and color to customize your graphs in bulk however you see fit.

Customize the in-cell pie charts in bulk