• 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.

Dynamic Comparison in Butterfly Chart
Charts and Visualization

Dynamic Comparison in Butterfly Chart

June 28, 2021March 3, 2025 PKComments Off on Dynamic Comparison in Butterfly Chart
Dynamic Comparison in Butterfly Chart is useful when you want to compare the Sales or any other parameter for two employees or two Teams for multiple dates. We have used
Read More
Pivot Chart Tips
Charts and Visualization

3 Useful Tips for the Pivot Chart

May 16, 2021March 5, 2025 PKComments Off on 3 Useful Tips for the Pivot Chart
In this article, you will learn 3 useful tips for the Pivot Chart. Using these tips you can create an interactive Excel Dashboard. Learn and download interactive Excel Dashboard free
Read More
Dynamic Comparison Analysis Chart
Charts and Visualization

Dynamic Comparison Analysis Chart in Excel

May 3, 2021March 2, 2025 PKComments Off on Dynamic Comparison Analysis Chart in Excel
In this article, you will learn how to create a dynamic comparison Analysis Chart in Microsoft Excel. Using this chart you can compare one employee's performance with other all employees
Read More
Dynamic Pivot Table with Multiple Tables
Charts and Visualization

Dynamic Pivot Table with Multiple Tables using Power Query

January 31, 2021August 23, 2024 PKComments Off on Dynamic Pivot Table with Multiple Tables using Power Query
In this article, we have created a dynamic Pivot Table with Multiple Tables using Power Query. We have taken 4 different yearly Sales Table as given in below image- Dynamic Pivot
Read More
Circular Bullet Chart in Excel
Charts and Visualization

Vertical and Circular Bullet Chart in Excel

January 24, 2021March 2, 2025 PKComments Off on Vertical and Circular Bullet Chart in Excel
In this article, we have created Vertical and Circular Bullet chart in Excel with 3 levels of color. We have displayed the Target point also in this chart. You can
Read More
10 Pro Tips for Excel Charts
Charts and Visualization

10 Pro Tips for Excel Charts

January 10, 2021August 23, 2024 PKComments Off on 10 Pro Tips for Excel Charts
In this article, you will learn 10 Pro tips for Excel Charts. Using these tips, you can improve your productivity and visualization skill set in Excel. Below is the list
Read More
Hourly Project Planner
Charts and Visualization

Dynamic Hourly Project Planner (Gantt chart)

December 27, 2020February 18, 2025 PKComments Off on Dynamic Hourly Project Planner (Gantt chart)
Using Gantt charts for project management is not a new concept. Still, with the advent of advanced Excel features, creating a dynamic hourly Gantt chart has become more accessible than
Read More
Power Gantt Chart
Power Pivot Charts and Visualization Templates

Power Gantt Chart (Project Planner) for Project Management

October 11, 2020February 20, 2025 PKComments Off on Power Gantt Chart (Project Planner) for Project Management
In the article, we have created the Power Gantt Chart (Project Planner) for Project Management in Microsoft Excel with Power Pivot. You can use this template for your Project Management
Read More
Comparison Chart
Charts and Visualization

Stylish and Dynamic Comparison Chart

August 30, 2020March 2, 2025 PKComments Off on Stylish and Dynamic Comparison Chart
In the article,  we have created a stylish and dynamic comparison chart in Microsoft Excel. This chart can be used to compare the metric like -Sales, Revenue, profit, etc. between
Read More
Dynamic Filled Map
Charts and Visualization

Dynamic Filled map in Excel

August 23, 2020June 14, 2024 PKComments Off on Dynamic Filled map in Excel
In the article, You will learn how to create a dynamic filled map in Microsoft Excel. Filled Map is available with Office 365 subscription. You can display the Region, country,
Read More

Posts pagination

Previous 1 … 5 6 7 … 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