Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

Chapter 22

Using 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. ...