Data bars add visual magnitude indicators inside table cells. They help viewers compare numeric values without leaving the table.
Good uses for data bars
- Revenue by customer
- Percent complete
- Usage by account
- Score or ranking fields
- Inventory or capacity values
SQL shape
Return the numeric values you want to compare:
select
customer_name,
sum(revenue) as revenue
from orders
group by 1
order by 2 descselect
customer_name,
sum(revenue) as revenue
from orders
group by 1
order by 2 descTips
- Use data bars for numeric fields only.
- Sort the table by the data-bar column when ranking matters.
- Combine with number formatting for clearer values.