Skip to content Skip to sidebar Skip to footer
Home / Chart

Excel Pivot Chart Change Color Based On Value

Excel Pivot Tables and Charts are great tools to visualize and analyze data. However, sometimes it can be difficult to spot trends and patterns in the data. One way to highlight important information is by changing the color of the Pivot Chart based on the value of the data. In this article, we will explore how to change the color of a Pivot Chart in Excel.

Step 1: Create a Pivot Table

The first step is to create a Pivot Table. The Pivot Table should contain the data that you want to visualize. Once you have created the Pivot Table, select any cell within the table and click on the “Pivot Chart” button in the “Insert” tab.

Create Pivot Table In Excel

Step 2: Customize the Pivot Chart

Once you have created the Pivot Chart, you can customize it to your liking. You can change the chart type, add titles, and labels, and more. To change the chart type, simply click on the “Change Chart Type” button in the “Design” tab.

Customize Pivot Chart In Excel

Step 3: Change the Color of the Pivot Chart

To change the color of the Pivot Chart based on the value of the data, you need to use a feature called “Conditional Formatting.” Conditional Formatting allows you to format cells based on their value or condition. To apply Conditional Formatting to the Pivot Chart, follow these steps:

  1. Select the Pivot Chart.
  2. Click on the “Format” tab.
  3. Click on “Conditional Formatting”.
  4. Select “Color Scales”.
  5. Choose a color scale that suits your needs.
Change Color Of Pivot Chart Based On Value In Excel

Step 4: Edit Conditional Formatting Rules

If you want to edit the Conditional Formatting rules, you can do so by following these steps:

  1. Select the Pivot Chart.
  2. Click on the “Format” tab.
  3. Click on “Conditional Formatting”.
  4. Select “Manage Rules”.
  5. Select the rule that you want to edit.
  6. Edit the rule as needed.
Edit Conditional Formatting Rules In Excel

Step 5: Apply Conditional Formatting to Specific Data Points

If you want to apply Conditional Formatting to specific data points in the Pivot Chart, you can do so by following these steps:

  1. Select the data points that you want to format.
  2. Click on the “Format” tab.
  3. Click on “Conditional Formatting”.
  4. Select “New Rule”.
  5. Select “Format only cells that contain”.
  6. Select the condition that you want to use.
  7. Choose a format for the selected data points.
Apply Conditional Formatting To Specific Data Points In Excel

Conclusion

Changing the color of a Pivot Chart based on the value of the data is a great way to highlight important information in your data. Using Conditional Formatting, you can easily apply color scales to your Pivot Chart and edit them to suit your needs. By following the steps outlined in this article, you can create Pivot Charts that are both informative and visually appealing.

Related video of Excel Pivot Chart Change Color Based On Value