It is not everyday that a blog boasts of 1000th post. After blogging for 1999 days ie 5 years 5 months 24 days, finally, this is my thousandth post.

While this is not a real mile stone or anything, I want to use this post to say thanks. Without you, this mile stone means nothing to me. 🙂

Comparing values is one of the main reasons we make charts. Yesterday we have a post on using thermometer charts to quickly compare actual values with targets. Today we follow up the post with 10 charting ideas you can use to compare actual values with targets. Check out how bullet charts, thermometer charts, traffic lights, gauges, column charts, area charts can help you compare targets with actual performances. A review of best charting options when you need to compare.

Read the rest of the post to see the options and participate in poll.

Comparing values is one of the reasons why we make charts. So today I am going to teach you a handy little trick to make a thermometer like chart to compare targets with actuals. This type of chart is very useful when you have a bunch of sales targets and you want to measure how the performance has been.

We all know how to make comments on excel documents, just select the cell where you want a comment, press SHIFT+F2 and make the comment. But the comments are only visible when you open the workbook. What if you want to print out an excel file, but include all the comments as well?

Turns out you can do that with a hidden option in excel page setup.

Have you ever wondered how you can hide that 0 (zero) at axis bottom? Like shown beside. You can use custom cell formatting codes (or custom number formatting codes) to do just that. Just go to axis formatting and from the number tab set the axis number format to something like #,##0;-#,##0;; Read the rest of the post to learn more.

Here is a 2010 new year gift to all our readers – a free 2010 calendar excel file (a little secret: just change the year in “outline” sheet from 2010 to 2011, to get the next years calendar. It works all the way up to year 9999). You can even get a Printable PDF Calendar. There are 14 different sheets in the calendar file. First one is an outline calendar for the entire year. The next 12 are monthly calendars. And the last sheet shows a mini-calendar for the year 2010.

Read the rest of this post to know more and download the calendar.

In office 2007 (and 2010) you can immediately collapse the ribbon by pressing CTRL+F1. Thanks to Loranga for sharing this tip. More ribbon goodness | Free e-book to learn Excel Ribbon