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 | MyExcelOnline

 

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 | MyExcelOnline

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

Conditionally Format a Pivot Table With Data Bars | MyExcelOnline

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 | MyExcelOnline

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

Conditionally Format a Pivot Table With Data Bars | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Conditionally Format a Pivot Table With Data Bars | MyExcelOnline