Make Excel Data Come Alive with Visualization Tools

Excel 2007 has added great new Data Visualization Tools. Now, you can place a Bar Chart directly in the cells that contain your values. Wow! There is no need to create a separate chart to “paint the picture” for your audience.

You can add Data Bars, Color Scales and Icon Sets to help your data to come alive from the Conditional Formatting Command on the Home Tab of the Ribbon in Excel 2007. Watch this short video to see how it is done!
(Note: This is a repost so that I can send this video as a Podcast to the iTunes Store.)

You can subscribe to this Podcast at iTunes by clicking this link.

Learn how to “Master Excel in Minutes – Not Months!”

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

Trackbacks

  1. […] If you are using Excel 2007 and higher, note that you can also use this tip (rightmouse click in a cell) to filter by the selected cell’s Icon, Font Color and Cell Background Color. Data Visualization is one of the really great improvements introduced in Excel 2007. Click here to go to my video lesson on Data Visualization. […]

Speak Your Mind

*