Starting this week I will post cool infographics from around the web, 4-5 of them a week to inspire , to give more ideas on presenting information and to provide some eye candy for awesome readers @ Pointy Haired Dilbert.
Go ahead, click through these awesome graphics:
California Walkability Score Heat Map
Lee Byron took the Walksocre for california locations and highlighted them on the map to generate this beautiful infographic. [via flowingdata]
Mozilla Firefox vs. Internet Explorer Security Incidents – Cool Square Pie
This chart is nothing but a square pie chart (or totally defragged partition chart), effective, easy on eye and tells one point as Seth Godin suggested 🙂 [via coolinfographics]
This map shows % of land owned by federal government vs. total land for each state in the US map, pretty cool even though it could be difficult to immediately interpret anything due to varying areas of each state.
This is not entirely a chart, but uses the ideas to tell people how much they will be fined based on their how much their pants sagged. Pretty neat 😀 [via Publication Design]
Visualizing Large Text Data – The trick is in colors
The biggest challenge of the Petabyte Age won’t be storing all that data, it’ll be figuring out how to make sense of it.
well, we are fortunate to have people like Martin Wattenberg who thrive to get the meaning out of all those petabytes. [via FlowingData]
Hope you enjoyed these charts 🙂
Have any neat infographics / charts and want them to featured on this blog? Drop me a comment or email me at chandoo [dot] d [at] gmail [dot] com.
3 Responses to “How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial”
Hi Chandoo,
I am responsible for tracking when church reports are submitted on time or not and the variations from the due date for submission.
Here is the Scenario;
The due date for the submission of monthly reports is on the 5th of each month. and I would like to know how many reports have been submitted on time (i.e, those that have been submitted on or before the due date) I would also want to track those reports that have been submitted after the due date has passed.
How can I create such a tracker?
Hi Chandoo,
I am a member of your excel school.
I was trying to create SOP Tracker I follow all your steps but I keep this error below.
The list source must be a delimited list, or a reference to a single row or cell.
I try looking on YouTube for answer but no luck.
can you help on this?
thanks
Carl.
Dear Mr. Chando,
Rakesh, I'm working in a private company in the UAE. Recently, I'm struggling to get more details about the staff sick, annual, unpaid, and leaves. I would like to get a tracker in excel. Could you please help me in this situation?
I also watching your videos in YouTube. i hope you can help me on this situation.