Percent Bars enable you to see numeric data as bar, where the cell is filled as a % of its value against the maximum value for the column.
You can create Ranges in the Percent Bar so the colour in the cell will vary depending on which range its value falls.
Other options include a back colour for the Bar, whether to see the cell value, and whether to display that value as a percentage of the total.
In this example we created 3 Percent Bars:
- Item Count - using the default colours and a tooltip showing the cell value
- Invoiced - with 3 ranges: 0-500 (red), 500-1000 (orange) and 1000-2000 (green)
- Item Cost - with non-default range and background colours and displaying both the cell and percentage value