Data bars display as horizontal bars in a cell, in varying in width based on the magnitude of a cell's content. Learn how you can use this feature to make your data stand out.
- [Instructor] In addition to using conditional formatting…to apply a background color or font change or a border,…we can also use a feature called data bars.…And in this worksheet called data bars,…we're selecting column D first of all,…we want the difference in the years to stand out a bit.…Conditional formatting on the home tab,…data bars, and as I slide over these choices,…there's six of them for gradient fill…and I think right away most people would say…could we make the column wider…to make these stand out a little bit better?…Do notice that the nature of the color here…is that it's solid on the left…and it tapers off into almost white on the right side.…
I'm going to choose the blue here…and then immediately make the column wider.…Another thought is some of the numbers are obscured.…If we make the column even wider can we see them better?…Let's try that, let me just move this boundary a bit more.…No matter how wide we make this,…it still might overlap some of the numbers.…Now of course you can read them probably.…
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows