How to Change Slicer Color in Excel (with Quick Steps)

This article provides guidelines on how to change the slicer color in Excel. By following these simple instructions, you can add visual appeal to your pivot table and make it easier to interpret the data.

Overview of Changing Slicer Color in Excel

In the Pivot Table above, a Slicer named Vendor has been added. And the color of the Slicer has been changed as you can see the Slicers before and after changing color. So, let’s dig deeper.

What Is a Slicer in Excel

A slicer is a graphical filtering interface in Microsoft Excel that enables users to filter data in a PivotTable, PivotChart, or Table in a more user-friendly manner. This feature was introduced in Excel 2010 and has since become a widely used tool for data analysis and visualization.

How to Insert Slicer in Excel with Pivot Table

In this section, we will learn to add Slicer in a Pivot Table. To add Slicer in a Pivot Table,  follow the instructions ahead and

  • Select anywhere in the Pivot Table.
  • From Insert Ribbon, Click on the Slicer
  • From the Insert Slicers Dialogue Box, select Vendor, and Product.
  • Press OK.

Process of Inserting Slicer in Excel

  • Two Slicers named Vendor and Product will appear as shown in the image below.

Addition of Two Slicer Vendor and Product

Step-by-Step Procedures to Change Slicer Color in Excel

Now, we will change the color of the Slice of the above-mentioned Pivot Table. Make sure to follow the instructions and image below.

Step 1: Use Built-in Slicer Formats in Excel

  • Select the Vendor Slicer.
  • From the Slicer Ribbon, Click on the More Option as shown in the image below.

Process of Adding Color to the Slicer

  • Select the preferable color.

Selecting Preferable Color

  • Color Slicer will appear then as shown in the image below.

Slicer with Preferable Color

Read More: How to Format Slicer in Excel

Step 2: Create Custom Slicer Style in Excel

You can also make a Custom slicer for your Pivot Table. To do so, follow the instructions.

  • From Ribbon, select Slicer.
  • Click the More Option as shown below.

Go to the Slicer Ribbon

  • Click on New Style Slicer.

Click on New Slicer Style

After clicking, a Dialogue Box will appear.

  • Give a preferable name for the style of the new Slicer.
  • Click on Format.

Create Customized Slicer

Note about Slicer Element

  1. The “with data” slicer element in pivot tables displays values with data in the selected criteria.
  2. The “with no data” slicer element in pivot tables displays values that do not have data ( If the data was removed from the dataset after inserting Slicer ) in the selected criteria.
  • A Format Slicer Element Dialogue Box will appear here.
  • You can change the Font, Border, and Fill of the Slicer using this Dialogue Box

The Slicer shown below is done by using a custom format for Whole Slicer, Selected Item with Data, and Unselected Items with Data. 

Custom Formatted Slicer

Frequently Asked Questions

  • What is an interactive dashboard?

An interactive dashboard is a visual representation of data that allows users to interact with and manipulate the data displayed. It usually consists of a set of visualizations, such as charts, graphs, tables, and maps, that are linked to each other and can be updated in real-time based on user inputs.

  • What’s the difference between a slicer and a pivot table?
Feature Slicers Pivot Table Filters
Type of tool Visual interface Dropdown menu
Functionality Filters data based on selection Filters data based on selection
Appearance Visual representation of filters Text representation of filters
Ease of use Intuitive and user-friendly Requires some knowledge of pivot tables
  • Can you make a slicer without having a pivot table?

Yes, in Excel, you can create a slicer that is not tied to a pivot table. Here are the steps:

  1. Select the range of cells that you want to create the slicer.
  2. Go to the “Insert” tab on the ribbon.
  3. Click on “Slicer” in the “Filters” section.
  4. In the “Insert Slicers” dialog box, select the field that you want to filter.
  5. Click “OK” to create the slicer.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


To summarize, coloring slicers in a pivot table is an effective way to enhance the visual appeal, and improve the readability of your data analysis. With the help of this step-by-step guide, you can easily add colors to your slicers and make your pivot table more engaging and informative. By experimenting with different color combinations, you can create a customized pivot table that effectively communicates your data insights to your audience.

Related Articles

Get FREE Advanced Excel Exercises with Solutions!
Zahid Shuvo
Zahid Shuvo

Zahid Hasan Shuvo, a Naval Architecture and Marine Engineering graduate from BUET, Bangladesh, has contributed nearly a year to the Exceldemy Project as an Excel and VBA Content Developer. Within this timeframe, he has crafted over 8 tutorial articles, and besides offering valuable solutions to aid users effectively. Zahid also expresses keen interests in Excel & VBA, Data Analysis, Machine Learning, AI Engines, and Prompt Engineering, showcasing a diverse skill set and contributing to the dynamic environment of... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF