Visualizing Your Data in Excel 2007

Excel 2007 makes it easy to “visualize” your data – directly in the cells of your worksheet! You do not need to take the time and effort to create a chart to visually represent your information.

You just take advantage of the tools in the newly-engineered Conditional Formatting command in Excel 2007. In this lesson I show you how to visualize your data as:

  • Data Bars – you get the equivalent of a Bar Chart drawn inside the data cells.
  • Icon Sets – pick from groups of 3, 4 or 5 Icon sets – for example, to show the data in the top third of your data range.
  • Color Scales – to add gradations of colors as numbers increase or decrease.

If you liked this tip and my style of Excel training, I invite you to visit my online store to purchase my DVD, “The 50 Best Tips for Excel 2007.”

You can view and download this Excel video lesson – for free – as a Podcast. Follow this link to visit my Podcast, Danny Rocks Tips and Timesavers” at the iTunes store.

You can also watch this Excel video lesson on YouTube.

Related Excel Videos:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind