• Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • DownloadsPopular
    • Excel VBA Tools
    • Dashboard
      • Excel Dashboard
      • KPI Dashboard
      • Power BI Dashboard
    • Charts
      • Progress Charts
      • Info-graphics
      • Animated Charts
      • Comparisons
      • Gantt Charts
      • Heatmaps
      • Speedometers
      • Timelines
    • Inventory Management
    • HR and Payrolls
    • VBA Automation
    • Utilities and Converters
    • Checklist
    • Calendars
    • Data Analysis
    • Excel Templates
    • Financial Tools
    • Project Management
    • Sales and Marketing
    • Productivity
  • Excel Dashboard
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • 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.

Spotlight Visualization
Charts and Visualization

Spotlight Visualization in Excel (Part-2)

June 22, 2019March 10, 2025 PKComments Off on Spotlight Visualization in Excel (Part-2)
This is the second part of Spotlight visualization. Here we have used spotlight to highlight top performer in the chart. We have created a Column Chart for Team Manager wise
Read More
Spotlight Visualization
Charts and Visualization

Spotlight Visualization in Excel (Part-1)

June 19, 2019March 11, 2025 PKComments Off on Spotlight Visualization in Excel (Part-1)
This is the first part of Spotlight visualization in excel Here we have used RAG (Red, Amber and Green) color code to display metric performance like – Service Level, Quality Score
Read More
Stylish Traffic Lights
Charts and Visualization

Stylish Traffic Lights in Excel

June 5, 2019March 5, 2025 PKComments Off on Stylish Traffic Lights in Excel
You can create very attracting info-graphics with the help of Auto shapes. Here we are giving an example of this. We have created stylish and beautiful Traffic lights  in Excel.
Read More
Stylish Pivot Chart
Charts and Visualization

Stylish Pivot Chart with Slicer in Excel

May 27, 2019March 4, 2025 PKComments Off on Stylish Pivot Chart with Slicer in Excel
We are back with one more stylish chart but this time we have used a pivot chart and connected it with a slicer. We have displayed employee wise sales on
Read More
Line Chart with RAG Background
Charts and Visualization

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

May 20, 2019March 5, 2025 PKComments Off on RAG (Red, Amber and Green) Analysis Chart in Excel
RAG (Red, Amber and Green) Analysis Chart in Excel is very useful to analyze the performance. We have designed this chart using Stacked column chart and Line chart. You can
Read More
3D Container Chart
Charts and Visualization

3D Container Pivot Chart with Slicer and Timeline

May 15, 2019March 11, 2025 PKComments Off on 3D Container Pivot Chart with Slicer and Timeline
This time I am back with a beautiful 3D container Pivot Chart with the slicers and Timeline. We have displayed the sales conversion by Zone on the chart. We have
Read More
3D Pyramid Chart
Charts and Visualization

3D Filled Pyramids Chart in Excel

May 12, 2019March 4, 2025 PKComments Off on 3D Filled Pyramids Chart in Excel
3D Filled Pyramids chart have been designed to display the KPI metrics like Sales Conversion, Service Level or any other KPI in percentage. You can display multiple categories on horizontal
Read More
Sales Funnel Chart
Charts and Visualization

Dynamic Sales Funnel Chart with Slicers

May 8, 2019March 5, 2025 PKComments Off on Dynamic Sales Funnel Chart with Slicers
In this article you will learn how to create dynamic Sales Funnel Chart with Slicers. This Chart can be used in your business dashboard or presentations. Below are the data
Read More
Disk Pie Chart
Charts and Visualization

3D Disk Pie Chart in Excel

April 11, 2019September 20, 2024 PKComments Off on 3D Disk Pie Chart in Excel
In today's world, data visualization has become an essential part of business presentations and reporting. It helps to communicate complex information in a simple and visually appealing way. One of
Read More
Stunning Thermometer Chart
Charts and Visualization

Info-graphics: Stunning Thermometer Chart in Excel

April 3, 2019March 5, 2025 PKComments Off on Info-graphics: Stunning Thermometer Chart in Excel
I am back with one more innovative chart which is a Stunning Thermometer Chart. This chart can be used for display KPI metrics. You can display your data by category
Read More

Posts pagination

Previous 1 … 9 10 11 … 16 Next
  • Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • DownloadsPopular
    • Excel VBA Tools
    • Dashboard
      • Excel Dashboard
      • KPI Dashboard
      • Power BI Dashboard
    • Charts
      • Progress Charts
      • Info-graphics
      • Animated Charts
      • Comparisons
      • Gantt Charts
      • Heatmaps
      • Speedometers
      • Timelines
    • Inventory Management
    • HR and Payrolls
    • VBA Automation
    • Utilities and Converters
    • Checklist
    • Calendars
    • Data Analysis
    • Excel Templates
    • Financial Tools
    • Project Management
    • Sales and Marketing
    • Productivity
  • Excel Dashboard
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • 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