O'Reilly logo

Excel 2016 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

22. Using Data Visualizations and Conditional Formatting

Many people feel their eyes glaze over when they encounter a screen full of numbers. Fortunately, Microsoft offers data-visualization features to Excel that make those screens full of numbers easier to interpret.

The following are some of the possibilities in data visualization:

Image Adding data bars (that is, tiny, in-cell bar charts) to cells based on the cell value. In Excel 2016, data bars can be negative, include an axis, and have new scaling options.

Image Adding color scales to cells based on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required