KPI Chart Archives - Page 2 of 4 - PK: An Excel Expert

Spotlight Visualization in Excel (Part 1): Dynamic RAG Stoplights

June 19, 2019October 9, 2026 PKComments Off

Spotlight visualization in Excel turns three plain KPI percentages into stage-style lights that glow red, amber or green on their own. In this first part you build RAG (Red, Amber

Power BI

Liquid Fill Gauge in Power BI: Custom Visual Setup Guide

June 10, 2019October 9, 2026 PKComments Off

The Liquid Fill Gauge in Power BI is a custom visual that shows a single percentage as a circle filling with animated liquid. It is an eye-catching way to show

Charts and Visualization

RAG (Red, Amber and Green) Analysis Chart in Excel

May 20, 2019October 9, 2026 PKComments Off

A RAG analysis chart in Excel draws your monthly results as a line on top of red, amber and green bands, so you can see at a glance which months

Charts and Visualization

3D Container Pivot Chart in Excel with Slicer and Timeline

May 15, 2019October 9, 2026 PKComments Off

A 3D container pivot chart shows a percentage as a liquid level inside a glass-like box: the solid part is what you achieved and the see-through part is what is

Charts and Visualization

Thermometer Chart in Excel: Stunning Infographic Step by Step

April 3, 2019October 9, 2026 PKComments Off

A thermometer chart in Excel is one of the clearest ways to show progress against a target: each bulb fills up to the actual value, and the empty glass above

Charts and Visualization

Small Charts for Weekly Performance

March 31, 2019March 5, 2025 PKComments Off

While creating a dashboard, many times it happens when you don’t have sufficient space to place your multiple charts. However, there is a solution that is small charts. By using

Charts and Visualization

Beautiful and Stylish Circle Chart in Excel

March 28, 2019March 4, 2025 PKComments Off

In today's data-driven world, visualization of data is an essential aspect of decision-making. Excel is a powerful tool which can help you to create beautiful and effective visualizations for your

Charts and Visualization

3D Glass Chart in Excel

February 20, 2019March 4, 2025 PKComments Off

I am back with a very innovative and Informative chart that is 3D Glass Chart in Excel. This chart can be used to display a KPI metrics like Service Level,

Charts and Visualization

KPI Indicator Chart with Target in Excel (Version 2)

December 3, 2018October 9, 2026 PK0

A KPI indicator chart with target in Excel shows where your actual number sits on a red-to-green scale and tells you at a glance whether you hit the goal. This

Charts and Visualization

Informative KPI Indicator Chart in Excel (Version 1)

November 30, 2018October 9, 2026 PK0

An informative KPI indicator chart shows a single KPI on a red-amber-green scale with an arrow that points to the current value. PK builds it on ten 10% slices, from