课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Data bars for easy visual comparison

Data bars for easy visual comparison - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

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…

内容