From the course: Excel: Conditional Formatting for Beginners
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use data bars to display length or volume
From the course: Excel: Conditional Formatting for Beginners
Use data bars to display length or volume
- [Instructor] The first sheet in our chapter two file is called Data Bars. It's one of three colorful features that allow us to really accentuate the data. We're interested in showing and emphasizing the information in column D. How many years the people have been here. Let's select column D, and on Conditional Formatting on the Home tab, let's take a look at Data Bars. 12 different choices here. The first six are what we call Gradient Fill. And as I slide over the options, keep your eye on column D, see what's happening here. The bar is wider as the number gets higher. There's a bit of an optical illusion here, too. It looks as if the bars might be taller on the right side of the cell. That's because the color's fading a bit to the right. It looks taller. I prefer to use solid fill, but here the possibility is that the numbers are obscured. If you use gold, that tends not to happen. But even if you do use a darker…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.