Pages

Monday, August 27, 2012

Tell a story with pictures (Excel 2007)

One of the most dramatic additions to the Excel 2007 Conditional Formatting menu is the addition of icon sets. These icons are illustrative pictures that you can assign to data values for fast data analysis. The icons range from stop lights to flags to check marks and x’s. For example, you can assign green, yellow, and red flags to your sales reps’ monthly sales. Green flags indicate sales in the top third percentile, yellow flags indicate sales in the middle percentile, and the red flags designate sales in the bottom third percentile.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.