Excel Data AnalysisLesson 48Free preview

Excel Data Bars

This lesson is part of Excel · All levels

Summary

The data bar adds a colored bar inside the cell so that the size of the value is visible at a glance without reading the numbers. Available in the gradient fill and solid fill options, the length of the bar is automatically scaled to the highest value in the range. This visual is very helpful on sales tables and budget.

Key points

The data bars draw proportional bars inside the cell
Available gradient fill and solid fill
The length of the rod is scaled to the maximum value of the range
The numbers remain on the bar.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.