August 19

Guest Post: Rollover for Months and Years

Guest Post: Rollover for Months and Years

Reader Bert van Zandbergen sent me a cool modification to the instruction file in How to: highlighting cells using the rollover technique in Excel to include years and months – not just rows and columns. He writes:

I am an enthousiast reader of the blog ‘Option Explicit’. I changed the formula (see below) and made a version for showing Years and Months. Now you can use this tool for Management Information. This fantastic tool, combined with Named Dynamic Ranges gives the ultimate solution for making awesome interactive dynamic Excel charts. As soon as possible I will show you an example.           

Bert van Zandbergen, Beekbergen  – The Netherlands 

You can download the file, here: Rollover_MI model version 1.xlsm

Thanks Bert!

Loved this? Spread the word


About the Author

Jordan Goldmeier

Related posts

Microsoft Excel Visio Data Visualizer Add In for Excel: A Quick Guide

Read More

Highlighted Timeline Chart in Excel Without VBA: Raw and Uncut

Read More

Make Your Excel Spreadsheet into a Bitmap Image With This Excel Magic Trick

Read More

Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks

Read More
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!

>