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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Repeat All Item Labels In An Excel Pivot Table Whenever you create a Pivot Table the default layout is in Compact Form, which puts all the data in one column.Many people do not like this layout as you cannot copy and paste the data and do further analysis in another worksheet.The best layout to use is either the Outli...
Pivot Table Calculated Item Pivot Table Calculated Items allow you to do mathematical calculations with your Item List.  You can use any of the Excel mathematical equations, like /*+-%.The only limitation is that you cannot reference any cells.  Pivot Table Calculated Items can be used to calculate chan...
Pivot Table Conditional Formatting Inserting a Pivot Table is very easy to do in Microsoft Excel: Inserting a Pivot TableAdding some Conditional Formats to the Pivot Table allows a user to highlight key data in a split second.See how easy it is to add some color to your analysis.DOWNLOAD WORKBOOK...
Color Scales in a Pivot Table Color Scales are new in Excel 2010 and they highlight the smallest and largest data points within your Pivot Table.It works like a heat map, in that it gives the highest number a shade of color and the lowest number a different shade of color, so your numbers can stand out at...