Excel Conditional Bar Chart with Drop-down and Icons (This Chick's Trouble for Excel Hash)

Excel Conditional Bar Chart with Drop-down and Icons (This Chick's Trouble for Excel Hash)

 

How can you combine unrelated Excel features to create a visualization your boss will be proud of? That's what I try to do using Excel's FREQUENCY function, Form Controls, MAX formula & 3D models. My solution is an Excel dynamic bar chart with icons. 

 

It's not your standard bar chart. It's an Excel chart that's conditionally formatted: The highest value is conditionally formatted with an icon. The icons are automatically hidden for the remaining bars. We use a trick to get it conditionally formatted. There are a lot of Excel chart tricks used here if you pay close attention.  I'll also show you how you can use 3Dmodels in PowerPoint at the end of the video.

 

Related Topics:

• Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers) 
• Your Excel Printing Problems, Solved 
• Lock Cells and Protect Excel Worksheet - EVEN by Cell 
• Change CASE of text in Excel (3 ways including NO Formulas)