Pinterest Pixel

Conditionally Format a Pivot Table With Data Bars

Conditionally Format a Pivot Table With Data Bars Data Bars are a cool Conditional Formatting feature in... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Conditionally Format a Pivot Table With Data Bars | MyExcelOnline Conditionally Format a Pivot Table With Data Bars | MyExcelOnline

Conditionally Format a Pivot Table With Data Bars

Data Bars are a cool Conditional Formatting feature in Excel and they add a colored bar to your values.

The length of the data bar represents the value in the cell.  A longer bar represents a higher value.

You have a Gradient Fill or a Solid Fill to choose from as well as different pre-determined colors.

If you select the More Rules option then you can select more colors as well as many different values types to format.

Download workbookData-Bars.xlsx

 

STEP 1: Select any value inside the Pivot Table. Go to Home > Conditional Formatting > Data Bars > Any Gradient Fill

Conditionally Format a Pivot Table With Data Bars

 

STEP 2: Go to Formatting Options Icon and select the second option to apply the data bar formatting to the entire table.

Conditionally Format a Pivot Table With Data Bars

Now you have data bars showing up for the entire pivot table.

Conditionally Format a Pivot Table With Data Bars

STEP 3: Go to Formatting Options Icon and select the third option to apply the data bar formatting to the entire table while excluding the total column and row.

Conditionally Format a Pivot Table With Data Bars

You get a better visual representation as the totals do not affect the data bars!

Conditionally Format a Pivot Table With Data Bars

If you like this Excel tip, please share it
Conditionally Format a Pivot Table With Data Bars | MyExcelOnline Conditionally Format a Pivot Table With Data Bars | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Create Multiple Subtotals in Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...