Smashing Magazine is one of daily hangouts for new design ideas, inspiration and ogle fun. When they featured Pixel Breaker’s Polar clock last Friday on Top 10 creative ways to display time, I knew this could be an interesting visualization to do in excel. So I have created a donut chart in excel that can show current time. To refresh the clock, just hit f9.
In order to create this I have taken now() and used date time functions to figure out the current day, month, weekday, minutes, hour, seconds day(), weekday(), month(), minute(), hour(), second() respectively and tabulated them like this:
Then the donut chart was created and I have removed the blank portion’s fill color, border and adjusted the other colors.
Of course there are few differences between my chart and that of Pixelbreaker’s (shown aside):
- The chart is not animated, I didnt want to write any VBA, so the chart is not animated and in order to see the animation effect, you have to hold the F9 key
- The labels are outside, well, there is really no way I can put labels inside the donut stripes using excel. So I choose to leave them outside. But there is a problem with that too since with each passing second / minute / hour excel is realigning the labels to somewhere else in the plot area. So I removed the labels permanently and used excel cells directly beneath the chart to show them.
All in all it is a fun experiment in Excel to start another week of awesome tips.
Download the polar clock in excel using donut charts excel sheet and play around.
More on Clocks: Give your timeseries data a twist, plot around clock
More on Visualization fun: Tag clouds in excel using VBA, Square Pies in Excel, not everything is round
, Olympic Medals on a map
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.