Here are three questions you often hear from your boss:
- What changes are happening in our business and how do they look?
- Do you know how to operate this new coffee machine?
- Why does every list has 3 items?
Jokes aside, our urge to find change in environment predates cave drawing, slice bread and Tommy Lee Jones. So, today let’s examine a very effective chart that tells the story of change and re-create it in Excel.
How fast America changes its mind – Example chart
Here is a recent chart from Bloomberg, depicting how America has changed its mind about various social & political issues between 1787 & 2015. (Read the full article on Bloomberg)
Applying these concepts to sample business data
Of course, our business data won’t span two and half centuries. So let’s look at something more realistic, like market share changes for 7 product categories over the last 15 years.
Here is a chart we will create in Excel.
Narrating change over time story with Excel charts – Video tutorial
If you like the above chart, watch below video to learn how to create it. As the process is somewhat elaborate, I made a video explaining various steps and techniques. Watch it below (or click here to see it on our YouTube channel)
Download the Change over Time Excel Chart:
Please click here to download the workbook for this chart (Excel 2013 Version).
Please click here to download the workbook for this chart (Excel 2007/10 Version).
Examine the chart, formulas & formats to learn more.
How do you tell the story of change?
My favourite methods for narrating the story of change are,
- Waterfall charts
- Scatter plots – case study
- Conditional formatting – usage in Dashboards
- Animated charts – Hurricane Sandy trajectory
- Interactive charts – Grammy bump chart
What about you? What charts & techniques do you use to narrate the story of change using Excel? Please share your thoughts and ideas in the comments area.
11 Responses to “FREE Calendar & Planner Excel Template for 2025”
Hi,
I downloaded this 2025 Calendar template. I checked the custom tab. Is it possible to change the weekend Fri & Sat.
Thanks
It is. Just use the option for fri & sat weekend (should be 7).
Activities of some dates are not getting displayed on "Any month" and "printable calendar" sheets.
e.g. Activity of 24 Apr 25.
Can you check again? The date in "planner" sheet should be a proper date. When I tested with 24-apr-2025, it works.
Love this calendar... I have highlight planner dates enabled but all dates are blue, is it possible to customize the color based on the type assigned to each date?
What would be the right way to add more Holidays in the Customizations?
Inserting rows in the Holiday List causes the blank cells in the calendar to turn Blue.
This is amazing!!! The best I've seen so far!! Is it possible to update it to consider a column for the final date? That way, if an event lasts more than one day, it repeats in the calendar
How do we change/insert the customization "Icon Options" ?
You can adjust these from the settings tab.
Is there anyway this can turn into an academic calendar (ie. start month is July and runs all the way through June of next year)?
Is there a way to make it something that is more than a day without having to add it to every day of that week.