Data Bars are a new Conditional Formatting feature in Excel 2010 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 6 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 WORKBOOK

Data Bars

HELPFUL RESOURCE:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

 

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

Share on Google+

Google+