Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges. This is a similar problem that I ran into at a recent company. Th
See how to create a hotel occupancy chart using advanced date functions, countif formulas and conditional formatting. Also included is finding out how many days are in any month and if any d
Step-by-Step Tutorial on making a visual representation of Pass / Fail data in an Excel Chart.
This tutorial will show you how to conditionally format bubble colors in an Excel chart using the NA() function.
Tutorial and video on how to make an non-chart excel chart using conditional formatting techniques, tips and tricks. A NOAA National Weather Service Heat Index
Halloween Chart - How to make a conditional radar chart that uses custom markers to have a spider chase a fly on a web graph