How to Create Bar Charts Using Excel Conditional Formatting
For more Excel Dashboard tricks visit me at bradedgar.com.
In this video tutorial I'll show you how you can use Excel conditional formatting to create in cell bar charts that change with your data sets. In this particular case I use and create an Excel bar chart set that shows the number of days past due. On the top column I add a number from 1 to 110 and then I use custom number formatting (using only semi-colons) to display nothing in those header cells.
I then create and use conditional formatting using the formula type to create a formula that checks to see if the value in our data set is greater than the header value. If it is, I then conditionally format the cell to display a color for that number. This automatically changes as your data set changes. As past due increases, so do the cells that are conditionally formatted.
The key to doing this is using absolute and relative referencing, custom number formatting, conditional formatting and just some straight up awesome visual display techniques to get this thing to shine.
Other Resources and Links:
Relative vs. Absolute References in Formulas [spreadcheats]
chandoo.org/wp/2008/11/04/relative-absolute-references-in-formulas/
Excel 2013 Tutorial - Absolute vs Relative Cell Referencing
youtu.be/N7oq_MTboB8
Relative and Absolute Cell Reference, and Formatting
howtogeek.com/school/microsoft-excel-formulas-and-functions/lesson3/
Use Excel's conditional formatting feature to display simple icons
techrepublic.com/blog/microsoft-office/use-excels-conditional-formatting-feature-to-display-simple-icons/
10 cool ways to use Excel's conditional formatting feature
techrepublic.com/blog/10-things/10-cool-ways-to-use-excels-conditional-formatting-feature/
Excel Conditional Formatting - Data Bars
contextures.com/excel-conditional-formatting-data-bars.html
Excel conditional formatting Icon Sets, Data Bars and Color Scales
ablebits.com/office-addins-blog/2014/06/05/excel-conditional-formatting-icon-sets-data-bars-color-scales/
Conditional Formatting in Excel 2007 and Excel 2010 spreadsheets using Formulas and Icon Sets
hubpages.com/technology/Conditional-Formatting-in-Excel-2007-and-Excel-2010-spreadsheets-using-Formulas-and-Icon-Sets
Cool things you can do with conditional formatting
exceljet.net/blog/cool-things-you-can-do-with-conditional-formatting
Microsoft Excel Conditional Formatting
chandoo.org/wp/tag/conditional-formatting/
5 Incredible Number Formatting Tricks That Will Impress Your Boss
bradedgar.com/5-incredible-number-formatting-tricks-will-impress-boss/
Excel Hide Zeros & Other Custom Number Formatting Tricks
excelarticles.com/LE10ePub-303.html
A Technique to Quickly Develop Custom Number Formats
chandoo.org/wp/2011/11/02/a-technique-to-quickly-develop-custom-number-formats/
10 Simple Tips To Make Your Excel Charts Sexier
searchengineland.com/10-tips-to-make-your-excel-charts-sexier-135407
5 simple rules for making awesome column charts
chandoo.org/wp/2013/08/29/rules-for-making-awesome-column-charts/
10 cool new charting features in Excel 2013
techrepublic.com/blog/10-things/10-cool-new-charting-features-in-excel-2013/
Variance on Clustered Column or Bar Chart
excelcampus.com/charts/variance-clustered-column-bar-chart/
How to create a bar or column chart in Excel
fiveminutelessons.com/learn-microsoft-excel/how-create-bar-or-column-chart-excel
-~-~~-~~~-~~-~-
Checkout my newest video: "How to Use the Vlookup Formula in you Excel Dashboard"
youtube.com/watch?v=MCBmPnaKf_g
-~-~~-~~~-~~-~-
- How to Create Bar Charts Using Excel Conditional Formatting ( Download)
- Simple Excel Trick to Conditionally Format Your Bar Charts ( Download)
- How to Make a Graph Change Color Based on Value | Conditionally Formatting Charts ( Download)
- Conditional formatting for Excel column charts ( Download)
- How to Create Progress Bars in MS Excel with Conditional Formatting ( Download)
- TECH-013 - Create a bar chart with conditional formatting in Excel ( Download)
- Create Bar Charts in Cells In Excel - Use a Formula, Conditional Formatting & Data Bars ( Download)
- How to Change Individual Bar Color in Excel | How to Change Color of One Bar in Excel Chart ( Download)
- Locate the highest performer | Querinfer ( Download)
- Excel Bar Chart - Conditional Formatting | FREE Download ( Download)
- Excel Conditional Formatting with Charts - Two Examples ( Download)
- Progress Bar in Excel Cells using Conditional Formatting ( Download)
- How to create progress bars in Excel with conditional formatting - Excel Tips and Tricks ( Download)
- How to Create Miniature Bar Charts in Excel with Conditional Formatting ( Download)
- Bar chart into cells with Conditional formatting and formula ( Download)
