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.

Dynamic Sales Funnel Chart in Excel with Slicers
Charts and Visualization

Dynamic Sales Funnel Chart in Excel with Slicers

May 8, 2019October 9, 2026 PKComments Off on Dynamic Sales Funnel Chart in Excel with Slicers
A sales funnel chart in Excel shows how many deals move from one stage to the next, from the first identified lead down to the deals you won. In this
Read More
3D Disk Pie Chart in Excel: Rounded 3-D Bevel Pie (Free File)
Charts and Visualization

3D Disk Pie Chart in Excel: Rounded 3-D Bevel Pie (Free File)

April 11, 2019October 9, 2026 PKComments Off on 3D Disk Pie Chart in Excel: Rounded 3-D Bevel Pie (Free File)
A 3D disk pie chart in Excel is a normal 3-D pie with one formatting trick: a large rounded bevel on the top and bottom of the series. That bevel
Read More
Thermometer Chart in Excel: Stunning Infographic Step by Step
Charts and Visualization

Thermometer Chart in Excel: Stunning Infographic Step by Step

April 3, 2019October 9, 2026 PKComments Off on Thermometer Chart in Excel: Stunning Infographic Step by Step
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
Read More
Small Charts for Weekly Performance
Charts and Visualization

Small Charts for Weekly Performance

March 31, 2019March 5, 2025 PKComments Off on Small Charts for Weekly Performance
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
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
Emp Rating Table
Charts and Visualization

Employee Rating Table in Excel

March 25, 2019March 10, 2025 PKComments Off on Employee Rating Table in Excel
An Employee Rating Table in Excel can be a powerful template to visualize and track employee performance across various parameters. So, instead of displaying simple numerical ratings, you can use
Read More
Resize and Relocate a Chart Using Excel Range with VBA
Charts and Visualization VBA

Resize and Relocate a Chart Using Excel Range with VBA

March 23, 2019October 9, 2026 PKComments Off on Resize and Relocate a Chart Using Excel Range with VBA
Want to resize and relocate a chart using an Excel range in one keystroke instead of dragging its corners around? In this tutorial you build a short VBA macro that
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
3D Glass Chart
Charts and Visualization

3D Glass Chart in Excel

February 20, 2019March 4, 2025 PKComments Off on 3D Glass Chart in Excel
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,
Read More

Posts pagination

Previous 1 … 10 11 12 … 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