- Create table with 8 reps
- Add an “Attainment %” formula column
- Format it as a percentage
- Highlight values below 90% in red
- Add a totals row
- Insert a column chart, actual vs target
- Auto-fit the columns
| Rep | Region | Target | Actual | Attainment % |
|---|---|---|---|---|
| Alice | North | 10,000 | 9,500 | 95.00% |
| Bob | South | 12,000 | 10,500 | 87.50% |
| Charlie | East | 8,000 | 8,500 | 106.25% |
| David | West | 15,000 | 12,000 | 80.00% |
| Eve | North | 9,000 | 9,200 | 102.22% |