How to Make a Heat Table in Microsoft Excel

Apr 14th, 2015 / Data Visualization
Just because I adore graphs doesn’t mean that I shun tables. I insert the occasional table inside the body of my report. When creating traditional tables, I follow the Dark Horse Analytics guide. When I’m presenting tables in a presentation, webinar, or full-color report, I create heat tables. Today I’m covering how to make a heat table in Microsoft Excel.
More »

At-a-Glance Patterns with Area Charts

Aug 27th, 2014 / Data Visualization
A few weeks ago I showed you how to create small multiples bar charts simply by creating a stacked bar chart in Excel with invisible white segments. In 5 minutes or less! Today’s strategy to use area charts takes a few minutes longer, but the result is worth it.
More »