Last Updated Mar 17, 2011 10:20 AM EDT
Take progress reporting, for example. You're probably used to seeing the status of projects identified in with text descriptions or percentages. But why not show progress with status bars, like this:
This technique was recently discussed in How-To Geek, and it's easy to do in Excel. In fact, it's an extension of a tip I showed you a few weeks ago. Just start by entering your various projects, and then add the percentage complete in the column to the right. Widen that column to give your progress bars more room, like this:
Now select the numbered cells, choose Conditional Formatting, Data Bars, and then pick the color you like. Note that all of these options leave the number in the cell, which might be exactly what you want.
If you'd rather have progress bar that only shows the bar, and no number, then choose Conditional Formatting, Data Bars, More Rules. In the New Formatting Rule dialog box, check the checkbox that says Show Bar Only, and click OK. That's it!