Excel Data AnalysisLesson 50Free preview

Excel Icon Sets

This lesson is part of Excel · All levels

Summary

Sets icon adds a small icon such as an arrow, traffic light, or a flashlight inside the cell according to the value. Each icon represents a part of the data distribution, for example the green arrow rises to high performance and the red falls to low. You can change the icon limit rules to fit your business criteria.

Key points

Icon Sets mark the value group with a visual icon
Example sets: arrows, flags, scores, and traffic lights
The icon limit can be changed from a percentage to an absolute value.
The icon appears alongside the number in the cell

Full lesson

Code examples and quizzes

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