Pinterest Pixel

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... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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.

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

 

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.

See also  GETPIVOTDATA Function

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 itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

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!