This template is conditionally formatted to automatically highlight data labels in different color when the values are below specified target / budget / threshold.
How to use and edit this chart template
To edit this chart template, execute following steps.
- Right click on the chart to open chart menu. Click Edit Data. This will open the linked Excel sheet (see video below).
- Enter category values in column A (plotted on X-axis) and corresponding data in column B (plotted on Y-axis).
- You can add your data manually or copy data from Excel or any other data source.
- Close the Excel sheet.
- Restyle and customize to change text, fonts, colors etc. to match your brand guidelines, corporate identity / corporate design and preferences.
- This template is conditionally formatted to automatically highlight X-axis category labels in different color when the values are below specified target / budget / threshold.
- File format: PPTX. Compatible with PowerPoint 2010 and above.
Use case example: Monthly calls report
The chart in above example presents number of calls made and emails sent each month by sales rep and compares them against target. The months / category labels (along X-axis) with below target achievement are automatically highlighted in red color.
