Ok, here is a brand new excel blog in the town, from Mike Alexandar, a Microsoft Excel MVP. The blog is called bacon bits. Wonder what bacon has got to do with spreadsheets, well, you will do well to know that his company is called datapig technologies. Mike has written some really cool excel books like Excel 2007 Dashboards & Reports For Dummies
Let us talk about the excel links I have come across recently.
Using XY Charts to draw state maps
Dick Kusleika provides a neat technique for creating US State Maps using XY Charts. Using XY Charts for maps is somewhat cumbersome. I have stopped trying that route after crashing excel fewtimes. Instead, I use Tushar’s method of shapes to construct maps. You can learn more about that here
Generating TinyURLs using Excel
Jimmy provides a simple VBA macro that can generate tinyurls from any given URL. This can be handy if you are planning use run a twitter campaign from excel sheet.
This is a classic Stephen Few article where he disapproves 2 inforgraphic visualizations and highlights all the mistakes in them. He asks “Is this the best infographics has to offer?” I echo with his opinions. That is one reason why I have stopped posting the cool infographics of the week series.
Help Jorge finish his data visualization e-book
If you have sometime, head over to Jorge’s Junk Charts blog and help him write his e-book on 101 Data Visualization Questions You Were Afraid to Ask. You can win a free copy if your question is selected.
How to design a filter for your dashboards / reports
Juice analytics highlights five features of effective filters. This is a very good lesson if you design dashboards and complex TPS reports where filtering is necessary. I thin the aspects of Selections and Impact are very relevant when designing spreadsheet based filters.
Do you want to share a useful excel or charting related link?
Send me an e-mail or drop a comment. I like to learn and share new stuff about excel, spreadsheets and charting. More so, I like to read emails from *you*. So go ahead…
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.