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

Charts and Visualization

In this category, you will find comprehensive tutorials on creating stunning charts and visualizations in Excel. Impress your colleagues and boss with attractive and informative visuals by following our step-by-step guides. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the process. Explore this category now and enhance your data analysis and presentation skills with Excel.

Chart Templates in Excel: Save and Reuse Your Favorite Charts
Charts and Visualization

Chart Templates in Excel: Save and Reuse Your Favorite Charts

July 9, 2018October 9, 2026 PK0
Chart templates in Excel let you format a chart once and reuse that exact look on any new data in a couple of clicks. Instead of removing gridlines, picking colours
Read More
Male and Female Infographic in Excel: Data-Driven Fill Chart
Charts and Visualization

Male and Female Infographic in Excel: Data-Driven Fill Chart

July 9, 2018October 9, 2026 PK0
A male and female infographic in Excel shows a gender-wise KPI - attendance %, headcount %, productivity or success rate - as two person icons that fill up with colour
Read More
Ultimate Speedometer in Excel: Shapes and VBA Gauge
Charts and Visualization

Ultimate Speedometer in Excel: Shapes and VBA Gauge

July 6, 2018October 9, 2026 PK0
This speedometer in Excel is one of PK's favourite visuals, and it is not a chart at all. The dial, the coloured arc, the glossy ball and the needle are
Read More
Project Plan in Excel
Charts and Visualization

Project Plan (Gantt Chart) in Excel

July 5, 2018February 18, 2025 PK0
Crafting a Project Plan (Gantt Chart) in Excel can initially appear to be an intimidating task. This is particularly true for those who are not well-versed with the nuances of
Read More
5 KPI Cylinder Chart in Excel: Show 5 Metrics in One Chart
Charts and Visualization

5 KPI Cylinder Chart in Excel: Show 5 Metrics in One Chart

July 5, 2018October 9, 2026 PK0
A KPI cylinder chart in Excel lets you show five metrics side by side in one compact, eye-catching visual. Each KPI gets its own glass cylinder, and the coloured fill
Read More
Employee wise deficit and surplus sales chart
Charts and Visualization

Employee Wise Deficit and Surplus Sales Chart

June 27, 2018March 9, 2025 PK0
In this article you will learn how to create an Employee Wise Deficit and Surplus Sales Chart. This chart will give 2 types of analysis. This will give an employee
Read More
Charts and Visualization

Conditional Formatting in Stylish Doughnut Chart

June 23, 2018March 9, 2025 PK0
In my last post I have explained how to create stylish doughnut chart in Excel. I hope you has enjoyed that chart. Now in this article, you will learn how
Read More
Charts and Visualization

Stylish Doughnut Charts in Excel

June 19, 2018March 8, 2025 PK0
In this article you will learn how to create 4 stylish doughnut charts in Excel. These doughnut charts are used to display the KPI metrics or progress of a project.
Read More
Multilayered Doughnut Chart in Excel Part 2: Team Performance
Charts and Visualization

Multilayered Doughnut Chart in Excel Part 2: Team Performance

June 14, 2018October 9, 2026 PK0
A multilayered doughnut chart in Excel stacks one ring per team, so you can compare five or six teams at a glance in a dashboard or presentation. This is Part
Read More
Multilayered Doughnut Chart-Part1
Charts and Visualization

Multilayered Doughnut Chart : Part-1

June 11, 2018October 10, 2026 PK0
In this article you will learn how to create a beautiful multilayered Doughnut Chart for KPI metrics. In this chart we can display 3 or 4 KPI metrics at a
Read More

Posts pagination

Previous 1 … 14 15 16 Next
  • 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
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT