Here is a simple but effective rule for your next dashboard.
Tell all versions of truth.
All versions? But there is only one version no?
Of course, there is only one version of truth (or data), but you can present that in different ways, thus creating different perspectives, offering different insights. By using an interactive element (slicers / form controls / VBA / hyperlinks) you can give users control to switch between perspectives. This creates a very powerful storytelling platform.
Here is a classic example of how to tell all versions of truth, based on the excellent Global house prices interactive chart on Economist website.
Watch the video on Chandoo.org YouTube Channel.
Recommended reading:
If you want to know more about how to present all versions of truth, check out below tutorials:
- Analytical charts – present different versions of data analysis in one go
- Customer service dashboard using Excel
- How to make your dashboards interactive – A comprehensive guide
Do you tell all versions of truth?
I am big fan of interactive charts in my dashboards. I feature them in all my creations.
What about you? Do you add multiple versions of analysis in one chart like above? Please share your experiences and tips in the comment box.
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.