Spreadsheet Tips

Visualize Data with Data Bars

August 20, 2019
A person selects a set of numbers and clicks Conditional Formatting > Data Bars, displaying a set of relatively-sized bars behind the data.

Data bars are a nice way to see the relative size of some numbers at a glance. You can find them in your conditional formatting options.

If you decide to use them, it's best to choose a low contrast color, so the visuals don't overpower the text (making it difficult to read). 😣