Charts and Visualization Archives - Page 10 of 16

Horizontal Timeline Chart using Scatter chart in Excel

July 5, 2019March 3, 2025 PKComments Off

Project management is a complex task that involves multiple aspects, including planning, execution, control, and closure. Among the crucial elements of successful project management is the use of timeline charts,

Charts and Visualization

Vertical Timeline Chart Using Scatter Chart in Excel (Dynamic)

July 3, 2019October 9, 2026 PKComments Off

A vertical timeline chart using a scatter chart in Excel is a clean way to show the milestones of a project from top to bottom. Dates run down a central

Charts and Visualization

Waffle Charts in Excel Without Macro: Dynamic Step-by-Step Guide

July 1, 2019October 9, 2026 PKComments Off

Waffle charts in Excel without macro are a smart way to show a percentage: a 10x10 grid where every cell is one percentage point, so 48% lights up 48 of

Charts and Visualization

Highlight Top Performer in Excel Chart with a Spotlight (Part 2)

June 22, 2019October 9, 2026 PKComments Off

Want to highlight the top performer in an Excel chart so nobody has to hunt for the biggest number? In this second part of the spotlight visualization series you build

Charts and Visualization

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

Charts and Visualization

Stylish Traffic Lights in Excel: Shapes + Conditional Formatting

June 5, 2019October 9, 2026 PKComments Off

Stylish traffic lights in Excel give your dashboard a glossy, 3-D status lamp for every KPI that turns red, amber or green on its own. The trick is simple: a

Charts and Visualization

Stylish Pivot Chart with Slicer in Excel (Step by Step)

May 27, 2019October 9, 2026 PKComments Off

A stylish pivot chart with slicer in Excel turns a plain employee sales report into an eye-catching, clickable visual. In this tutorial you build PK's teardrop chart step by step:

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

3D Filled Pyramids Chart in Excel for KPI Percentages

May 12, 2019October 9, 2026 PKComments Off

A 3D filled pyramids chart in Excel turns a KPI percentage into a pyramid that fills up from the bottom, like liquid in a glass. Each category gets its own