From the course: Excel: Tracking Data Easily and Efficiently

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Data bars for easy visual comparison

Data bars for easy visual comparison - Microsoft Excel Tutorial

From the course: Excel: Tracking Data Easily and Efficiently

Start my 1-month free trial Buy for my team

Data bars for easy visual comparison

“

- [Instructor] Here's something very simple that you can do to make a tracker look nice and be informative. Here we've got data about spring field trips and summer field trips and let's assume that we have another source of data that's bringing these sums in here so that we can see two people went to the abandoned mansion trip back in the spring. Here we go. Data bars. I'm going to highlight here, going to the home tab, conditional formatting, data bars, and we have various flavors to pick from. Green, red, let's grab this orange. Alright, check that out. And we can widen this out a bit. And we see the planetarium and the windshield wiper factory are out ahead of the rest. Now let's do this one other time and then we're going to be done. Highlight, conditional formatting, data bars, more rules. I want to show bar only. And okay, there we go. And there were options in there to change the formatting but…

Contents