Back to blog

Building a Color-Coded Calendar Grid in Excel

byNeil Malek

Building a Color-Coded Calendar Grid in Excel

People are always badmouthing Excel and working in various new and powerful data visualization tools. In this video, we duplicate the visualization technique described in this post to the subreddit /r/dataisbeautiful (https://www.reddit.com/r/dataisbeautiful/comments/a7uq76/the_precipitous_decline_in_white_house_press/) with Excel. The original graphic was built using R, but this is created entirely using Conditional Formatting.

View more about this topic

Related everyday office posts

Video tutorials Going Text to ROWS with Power Query

Going Text to ROWS with Power Query

Text to Columns is a common tool in Excel (although the Text to Columns feature in Power Query, called Split...

Video tutorials Power Query CRUSHES VLOOKUP

Power Query CRUSHES VLOOKUP

In this video, we compare your standard use of VLOOKUP – combining two tables – with the Left Outer Join...

Related recources

A Beginner’s Guide to Power Query

A Beginner’s Guide to Power Query

Power Query is Excel's new ETL tool - whether you’re talking about Excel or Power BI, when you extract, transform, and load the data into a report, you’re doing it with Power Query.