Home>Blogs>Charts and Visualization>Conditional Formatting in a Lollipop Chart in Excel
Conditional Formatting in Lollipop chart
Charts and Visualization

Conditional Formatting in a Lollipop Chart in Excel

Using the Conditional Formatting in any chart is very useful. It helps to audience to identify which category is meeting the target and which is not meeting. Here, we have used the Conditional Formatting in a beautiful Lollipop Chart. We also have created 4 variants of this chart with some different shapes which make it more eye catching.

Days wise sales are available on range “A1:B8” and target is available on range “H1”. Wherever sale value is less than the target value then it will be red otherwise it will be in green. It is a dynamic chart whenever target value will be changed color will changed accordingly.

Data Points and Target Value
Data Points and Target Value


Variant – 1 of Lollipop chart

Variant - 1
Variant – 1


Variant – 2 of Lollipop chart

Variant - 2
Variant – 2


Variant – 3 of Lollipop chart

Variant - 3
Variant – 3

Variant – 4 of Lollipop chart

Variant - 4
Variant – 4



Click here to download this Excel workbook.

Watch the step by step video tutorial:

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!