📎 This article includes 2 downloadable practice files ↓
Advertisement
Charts have no conditional formatting, but two helper series do the same job.
Above: =IF(B2>=C2, B2, NA())
Below: =IF(B2<C2, B2, NA())- Chart Above and Below as clustered columns; colour Above green, Below red.
- Format Series > Series Overlap 100% so they sit in one slot (only one has a value per rep).
- Add Target as a third series, change it to a line (or markers only) for the target level.
Practice data: Arjun, Kabir and Meera are green; Neha, Simran and Irfan red, with Irfan furthest below target.
💡
NA() is better than 0: zero draws a flat bar and a data label “0”; #N/A draws nothing.Practice
The practice workbook has the data and the helper formulas behind the chart (with automatic checks). Build the chart yourself, then open the finished examples file to compare. Excel built those charts and we checked their types and series.
📎 Practice files for this article
⬇ Download all 2 files (ZIP · 37 KB)
- 📗Practice workbookSix reps, actual and target, 5 tasks.⬇ XLSX · 13 KB
- 📗Finished chart examplesCombo, waterfall, dynamic, actual-vs-target, sparklines and heat map, built by Excel.⬇ XLSX · 35 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong