New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Informative Chart

Group of Circle Charts in Excel: KPI Doughnut Infographic
Charts and Visualization

Group of Circle Charts in Excel: KPI Doughnut Infographic

August 19, 2019October 9, 2026 PKComments Off on Group of Circle Charts in Excel: KPI Doughnut Infographic
A group of circle charts in Excel shows one headline KPI and its breakdown in a single, dashboard-ready picture. In this tutorial you build one for service level: a large
Read More
Forecast vs Actual Chart with Safe Zone Range in Excel
Charts and Visualization

Forecast vs Actual Chart with Safe Zone Range in Excel

July 31, 2019October 9, 2026 PKComments Off on Forecast vs Actual Chart with Safe Zone Range in Excel
A forecast vs actual chart with a safe zone range in Excel shows at a glance whether your real numbers stay close to plan. The actual values run as a
Read More
Multiple KPIs Visualization in Excel with Dynamic RAG Colors
Charts and Visualization

Multiple KPIs Visualization in Excel with Dynamic RAG Colors

July 10, 2019October 9, 2026 PKComments Off on Multiple KPIs Visualization in Excel with Dynamic RAG Colors
A multiple KPIs visualization in Excel lets you show ten KPIs in one eye-catching panel, with each result in a circle that turns red, amber or green on its own.
Read More
Waffle Charts in Excel Without Macro: Dynamic Step-by-Step Guide
Charts and Visualization

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

July 1, 2019October 9, 2026 PKComments Off on Waffle Charts in Excel Without Macro: Dynamic Step-by-Step Guide
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
Read More
Stylish Circle Chart
Charts and Visualization

Beautiful and Stylish Circle Chart in Excel

March 28, 2019March 4, 2025 PKComments Off on Beautiful and Stylish Circle Chart in Excel
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
Read More
Fish Chart in Excel: Step-by-Step Tutorial with Random Fish
Charts and Visualization

Fish Chart in Excel: Step-by-Step Tutorial with Random Fish

February 25, 2019October 9, 2026 PKComments Off on Fish Chart in Excel: Step-by-Step Tutorial with Random Fish
A fish chart in Excel turns a plain day-wise sales report into a small aquarium. Each day's sales value is shown by a fish that swims at the height of
Read More
Conditional Formatting in a Lollipop Chart in Excel (4 Variants)
Charts and Visualization

Conditional Formatting in a Lollipop Chart in Excel (4 Variants)

February 23, 2019October 9, 2026 PKComments Off on Conditional Formatting in a Lollipop Chart in Excel (4 Variants)
Adding conditional formatting in a lollipop chart in Excel lets your audience see at a glance which days hit the sales target and which did not: every value above the
Read More
KPI Indicator Chart with Target in Excel (Version 2)
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
Read More

Posts pagination

Previous 1 2
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy