Tag archive for Conditional Formatting

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

I bet you’ve got better things to do than fiddle with your spreadsheet for hours on end. And why rely on Excel’s default settings when you can easily format your spreadsheet to fit your exact preferences? There are numerous formatting adjustments you can make to…

Continue reading →

How to Make a Heat Table in Excel

How to Make a Heat Table in Excel

Just because I adore graphs doesn’t mean that I shun tables. I insert the occasional table inside the body of my report. Every report’s appendices are full of tables, tables, and more tables. When creating traditional tables, I follow the Dark Horse Analytics guide. When I’m…

Continue reading →

At-a-Glance Patterns with Area Charts

At-a-Glance Patterns with Area Charts

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 takes a few minutes longer, but the result is worth it. The Original: A Data…

Continue reading →