There are several charting principles. But the most effective of them all is “KISS”.
By kiss, I don’t suggest that you kiss the chart designer (although it might work). By kiss, I mean “Keep It Simple, Stupid”
Today I want to feature a very simple and effective chart from Wall Street Journal. It tells you the story of 11 US presidents, all the way from Truman to Bush and how their approval ratings were during the presidency.
OK, ok, show me the chart
Approval ratings of Past U.S. Presidents : From Truman to Bush
Well, so what is great about this chart?
First look at the amount of data, 11 US presidents, approval ratings from almost 60 years, someone else might have gone nuts and created huge amount of overlapping balls or animated dots or something else. But not the wise folks at WSJ. They chose to present the data in a simple yet very effective line chart. They have colored each president uniquely and added exact amount of grid lines and labels.
Aha, how can this help me?
Simple, “keep your charts simple”. No matter how complex your data is or how lengthy your formulas are, when it comes to presenting the results, simple charts and visualizations always outdo the more complicated and elaborated charts.
Hmm, Fair enough, why don’t you tell me some guidelines then?
- Prefer bar, column, line and XY scatter charts
- Keep your chart design minimalistic. Avoid un-necessary labels, grid lines and axis stuff
- Pick-up colors that go along with each other. Simple rule: either pick shades of same color or totally different colors that contrast.
- If you plan to highlight something, make it really stand out. I mean REALLY.
None of these rules are rocket science. They are common sense. But it is very easy to loose common sense in the plethora of functionality offered by the chart designing software (excel or something else).
Happy weekend, and yeah if you are still kissing your chart designer, may be its time you subscribed to our RSS Feed or E-Mail updates.
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.