Pinterest Pixel

Conditionally Format a Pivot Table With Data Bars

John Michaloudis
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.

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


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  Cannot group that selection in an Excel Pivot Table - SOLUTION!

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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