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

Method 1 – Use Fill Color Tool to Change Pie Chart Colors

  • Double-click on any of the slices in the pie chart.

Use Fill Color Tool to Change Pie Chart Colors

  • Right-click and select Fill.

Use Fill Color Tool to Change Pie Chart Colors

  • Select any color for the slice.

Use Fill Color Tool to Change Pie Chart Colors

  • The slice will change to the selected color.

How to Change Pie Chart Colors in Excel

  • Change other slice colors by following the same procedure.
  • Fill Color tool is in the Font group of the Home tab.

Use Fill Color Tool to Change Pie Chart Colors

  • Select More Colors.

  • The Colors window will open where you can customize colors as desired.


Method 2 – Apply Themes in Excel to Modify Pie Chart Colors

  • Select Colors in the Themes group of the Page Layout tab.

Apply Themes in Excel to Modify Pie Chart Colors

  • Choose a color set.

Apply Themes in Excel to Modify Pie Chart Colors

  • The slice colors will change.

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

  • In the Create New Theme Colors window, change colors as desired.
  • Click on Save.

Apply Themes in Excel to Modify Pie Chart Colors

Read More: How to Edit Legend of a Pie Chart in Excel


Method 3 – Change Pie Chart Colors in Excel with Chart Style

  • Go to Page Layout tab and choose Change Colors from the Chart Styles group.

Change Pie Chart Colors in Excel with Chart Style

  • Select the color from the options.

Change Pie Chart Colors in Excel with Chart Style

  • The pie chart color will change.

Change Pie Chart Colors in Excel with Chart Style

  • To change the background color,
    • Click on Shape Fill under the Shape Styles group from the Format tab.
    • Select any color.

  • Backgrund will change to the selected color.

Read More: How to Edit Pie Chart in Excel


Method 4 – Use Excel VBA Code to Change Pie Chart Colors

  • Color the cells D5:D9 manually with the Fill Color tool.

Use Excel VBA Code to Change Pie Chart Colors

  • Go to the Developer tab and select Visual Basic.

Use Excel VBA Code to Change Pie Chart Colors

  • In the visual basic window, Go to the Insert tab and select Module.

  • 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

  • Click on the Run Sub button or press F5 on your keyboard.

  • Click on Run in the Macros window.

  • The pie chart color will change.

Use Excel VBA Code to Change Pie Chart Colors

Read More: Excel Pie Chart Labels on Slices: Add, Show & Modify Factors


How to Format Pie Chart Color in Excel

  • Double-click on any slice of your pie chart.
  • Select Format Selection in the Current Selection group under the Format tab.

  • In the Format Chart Area pane, go to Chart Options and select Series “Amount”.

  • Change the Color from this section.

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

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

Read More: Add Labels with Lines in an Excel Pie Chart


Download Workbook


Related Articles


<< Go Back To Edit Pie Chart in ExcelExcel Pie ChartExcel ChartsLearn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sanjida Mehrun Guria
Sanjida Mehrun 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... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo