Lollipop Chart with X-Axis Labels Auto Highlight for Below Target

Use this lollipop chart PowerPoint template to highlight data labels in different color when the values are below specified target.

Chart Template for PowerPoint

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.

  1. Right click on the chart to open chart menu. Click Edit Data. This will open the linked Excel sheet (see video below).
  2. Enter category values in column A (plotted on X-axis) and corresponding data in column B (plotted on Y-axis).
  3. You can add your data manually or copy data from Excel or any other data source.
  4. Close the Excel sheet.
  5. Restyle and customize to change text, fonts, colors etc. to match your brand guidelines, corporate identity / corporate design and preferences. 
  6. This template is conditionally formatted to automatically highlight X-axis category labels in different color when the values are below specified target / budget / threshold.
  7. 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.

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest

Numbers have an important story to tell. They rely on you to give them a clear and convincing voice.

Stephen Few

Create Beautiful Custom Reports, Dashboards, Charts and Graphs in Minutes

115 Chart Templates . One time purchase . instant download