Look Who it Was Random video

Excel - First Look at Icon Sets, Data Bars, Color Scales in Excel Data Visualization - Episode 396

574 views · Published 12 October 2009 · 2:17 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: First Look at Icon Sets, Data Bars, Color Scales in Excel Data Visualization.

Welcome back to the MrExcel netcast, where we discuss all things Excel. In today's episode, we're diving into the world of data visualization in Excel 2007. This new version of Excel will be hitting retail shelves in January 2007, but if you're a corporate subscriber with MSDN, you may already have access to it. Check with your IT department to see if you can get your hands on Excel 2007 now!

Data visualization is a powerful tool for making sense of large sets of data. It allows you to see trends and patterns that may not be immediately apparent when looking at a sea of numbers. In Excel 2007, data visualization can be found under the Conditional Formatting drop-down on the home Ribbon. With just a few clicks, you can transform your data into easy-to-read charts and graphs.

One of the options under Conditional Formatting is Data Bars. This feature allows you to add in-cell bar charts to your data, with the size of the bar representing the value of the cell. This makes it easy to see which numbers are the largest and smallest in your data set. And with live preview, you can see the changes in real-time as you hover over different data bar options.

But that's not all - Excel 2007 also offers a Color Scale option under Conditional Formatting. This applies a heat map to your data, with the largest numbers in red and the smallest in green or blue. This is another great way to spot trends and patterns in your data, and have your eye drawn to the most important numbers. So don't forget to explore all the options in Data Visualization to make the most of your data.

Thanks for tuning in to today's netcast from MrExcel. We'll be back tomorrow with more tips and tricks for Excel 2007. Don't forget to subscribe to our channel and hit the notification bell so you never miss an episode. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to Excel 2007 features
(00:28) Early access for corporate subscribers
(00:39) Data Visualization in Conditional Formatting
(01:13) In-cell bar charts for data analysis
(01:27) Enhancing tables with Data Visualizations
(01:37) Color Scale option in Conditional Formatting
(01:47) Spotting trends with heat maps
(01:57) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Color Scale
Conditional Formatting
Data Bars
Data Visualization
Heat map
Largest numbers
New features in Excel 2007
Smallest numbers
Table of numbers
Trends in data

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152683/



A look at Excel 2007 data bars and color scale features. These new features allow you to quickly see the largest/smallest values in a sea of numbers. Episode 396 shows you how.

This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!

More from this channel