Microsoft Excel 2019 Inside Out

Chapter 22Using Data Visualizations and Conditional Formatting

Using Data Bars to Create In-Cell Bar Charts

Using Color Scales to Highlight Extremes

Using Icon Sets to Segregate Data

Using the Top/Bottom Rules

Using the Highlight Cells Rules

Tweaking Rules with Advanced Formatting

Combining Rules

Extending the Reach of Conditional Formats

Special Considerations for Pivot Tables

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:

• Adding data bars (that is, tiny, in-cell bar charts) to cells based on the cell value. ...