How to Change Pie Chart Colors in Excel (4 Easy Ways)

The pie chart is one of the widely used charts in excel. We use it for data presentation in a summarized way over a specific period of time. The colors in a pie chart help to determine each data point. These colors are easy to change in excel. So in this article, we will learn how to change pie chart colors in excel in 5 easy ways.

Table of Contents hide

Download Workbook

4 Easy Ways to Change Pie Chart Colors in Excel

1. Use Fill Color Tool to Change Pie Chart Colors

2. Apply Themes in Excel to Modify Pie Chart Colors

3. Change Pie Chart Colors in Excel with Chart Style

4. Use Excel VBA Code to Change Pie Chart Colors

How to Format Pie Chart Color in Excel

Conclusion

Download Workbook

Download the sample file and try it yourself.

Change Pie Chart Colors.xlsm

4 Easy Ways to Change Pie Chart Colors in Excel

For illustration, we have taken a dataset as an example. The dataset shows expenditure sectors with amounts among 5 friends on a trip.

Now, select the dataset and create a Pie chart from the Charts group in the Insert tab.

Finally, we have our desired pie chart of expenses.

Now, let’s see 4 easy ways to change this pie chart’s colors in excel.

1. Use Fill Color Tool to Change Pie Chart Colors

The Fill Color tool is an easy one to change the pie chart colors. Let’s see how it works.

First, double-click on any of the slices in the pie chart.

Then, right-click and select Fill.

After that, select any color you prefer for the slice.

Finally, you can see that the selected slice color is changed now.

Similarly, you can also change other slice colors by selecting them individually.

You can find the similar Fill Color tool in the Font group of the Home tab.

If you want to explore an extensive range of colors, simply select More Colors below the color list.

Here, in the Colors window, you have a wide range of colors to choose from for your pie chart.

2. Apply Themes in Excel to Modify Pie Chart Colors

The Themes tool helps to change all slice colors of the pie chart at a time. Follow the steps below to perform this:

To begin the process, select Colors in the Themes group of the Page Layout tab.

Next, choose any color set you prefer for the pie chart.

Finally, all the slice colors are changed at once in the excel pie chart.

To edit any color of the selected color set, go to Customize Colors below the color set options.

Here, in the Create New Theme Colors window change any slice colors you want.
Click on Save.

Read More: How to Format a Pie Chart in Excel

Similar Readings

3. Change Pie Chart Colors in Excel with Chart Style

In this section, we will discuss the process to change pie chart colors with the Chart style. Let’s see the steps below:

First, choose Change Colors under the Chart Styles group in the Page Layout tab.

After that, select any color set from the options in the drop-down section.

That’s it, we have our newly colored pie chart in excel.

To ornament it more, you can change the background color of the pie chart as well.
Simply click on the Shape Fill icon under the Shape Styles group from the Format tab.
Then, select any color you prefer for the background.

Finally, here is the final output.

4. Use Excel VBA Code to Change Pie Chart Colors

In this last segment, we will change pie chart colors with Excel VBA code. Let’s follow the process below:

First, color the cells D5:D9 manually with the Fill Color tool.

Then, select Visual Basic from the Code group under the Developer tab.

Following, a new visual basic window appears.
Here, select Module from the Insert tab.

Now, insert the code below on the blank page.

Private Sub SheetActivate()
    Dim ch As ChartObject
    Dim l As Long
    Dim vntValues As Variant
    Dim st As String
    Dim myS As Series

    For Each ch In ActiveSheet.ChartObjects

        For Each myS In ch.Chart.SeriesCollection

            If myS.ChartType <> xlPie Then GoTo SkipNotPie

            s = Split(myS.Formula, ",")(2)
            vntValues = myS.Values

            For l = 1 To UBound(vntValues)
                myS.Points(l).Interior.Color = Range(s).Cells(l).Interior.Color
            Next l
SkipNotPie:
        Next myS
    Next ch
End Sub

After that, click on the Run Sub button or press F5 on your keyboard.

Next, click on Run in the Macros window.

Finally, you can see the pic chart color has changed according to the reference cells’ color.

How to Format Pie Chart Color in Excel

Here is a quick overview of how to format a pie chart color in excel.

First, double-click on any slice of your pie chart.
Then, select Format Selection in the Current Selection group under the Format tab.

After that, choose Series “Amount” among the Chart Options in the Format Chart Area pane.

Now, change the Color from this section.
You can do this for each slice if it is necessary.

Keep the Vary colors by slice option checked if you want different colors in each slice.
Otherwise, mark it unchecked to keep all the colors the same.

Explore the Format Chart Area pane for more pie chart modification options.

Conclusion

In this article, we tried to guide you on how to change pie chart colors in excel in 4 easy ways. We also went through some quick formatting tricks. Let us know if you can suggest more methods. Follow ExcelDemy for more excel related blogs.