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+

Related Posts

Pivot Table Number Formatting You can easily format your Pivot Table values simply by Right Clicking on a value and choosing Number Format.  Then you can choose from the many different formats, like Number, Currency, Percentage or Custom. DOWNLOAD EXCEL WORKBOOK   STEP 1: Right click in the Pi...
Show The Percent of Grand Total With Excel Pivot T...   Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF GRAND TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sal...
Lock the Excel Pivot Table but not the Slicer Sometimes when you are sharing an Excel Pivot Table with your colleagues you do not want the other user(s) to mess with your Pivot Table layout and format. What you can do is lock the Pivot Table and only allow the user(s) to select the Slicers, making your report interact...
Pivot Table Calculated Field Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List.  You can use any of the Excel mathematical equations, like /*+-%. The only limitation is that you cannot reference any cells.  Pivot Table Calculated Fields can be used to calculate p...