Data bars is a conditional formatting option that will make your data easier to visualize it without the use of charts.
If you want to communicate your numbers visually, data bars can definitely will help you. To display data bars to your data, do the following.
1. Select your data range
2. Go to Home tab.
3. Select Conditional Formatting.
4. Select Data Bars.
5. Select a color scheme.
There are two sets of Data Bar options -- Gradient Fill and Solid Fill.
- Solid Fill is a better choice if the data bars if the numbers will be hidden in the cells (instructions below)
- Gradient Fill is better if the numbers will be visible in the cells -- the lighter colours at the end of the gradient make it easier to read the numbers.
NOTE: Change the numbers to bold font, so they are easier to see.