In this article, we have created Vertical and Circular Bullet chart in Excel with 3 levels of color. We have displayed the Target point also in this chart. You can use this chart to display the KPI metric like Service Level, Quality Score or Gross Margin etc. This chart is useful to show Target Vs Actual value.
24 Jan 2021
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.https://www.pk-anexcelexpert.com
Using the Conditional Formatting in any chart is very useful. It helps to audience to identify which category is meeting
In the article, we have created the Powerful Gantt Chart (Project Planner) for Project Management in Microsoft Excel with Power