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.


Download Workbook

Download the sample file and try it yourself.


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.

How to Change Pie Chart Colors in Excel

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

How to Change Pie Chart Colors in Excel

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.

Use Fill Color Tool to Change Pie Chart Colors

  • Then, right-click and select Fill.

Use Fill Color Tool to Change Pie Chart Colors

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

Use Fill Color Tool to Change Pie Chart Colors

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

How to Change Pie Chart Colors in Excel

  • 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.

Use Fill Color Tool to Change Pie Chart Colors

  • 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.

Apply Themes in Excel to Modify Pie Chart Colors

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

Apply Themes in Excel to Modify Pie Chart Colors

  • 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.

Apply Themes in Excel to Modify Pie Chart Colors

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.

Change Pie Chart Colors in Excel with Chart Style

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

Change Pie Chart Colors in Excel with Chart Style

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

Change Pie Chart Colors in Excel with Chart Style

  • 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.

Read More: How to Edit Pie Chart in Excel (All Possible Modifications)


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.

Use Excel VBA Code to Change Pie Chart Colors

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

Use Excel VBA Code to Change Pie Chart Colors

  • 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

Use Excel VBA Code to Change Pie Chart Colors

  • 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.

Use Excel VBA Code to Change Pie Chart Colors


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.


Related Articles

Guria

Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo