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

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 Chart
Charts and Visualization VBA

Resize and Relocate the Chart using Excel Range

March 23, 2019September 17, 2024 PKComments Off on Resize and Relocate the Chart using Excel Range
In this article you will learn a trick to resize and relocate a chart using VBA. We have created a shortcut key Shift+Ctrl+R to resize and relocate active chart. You
Read More
Fish Chart in Excel
Charts and Visualization

Fish Chart in Excel

February 25, 2019March 4, 2025 PKComments Off on Fish Chart in Excel
Fish Chart is my lasted innovation. I have used it to display sales data points. The new thing is that fishes are getting changed randomly whenever worksheet is recalculated.  I
Read More
Conditional Formatting in Lollipop chart
Charts and Visualization

Conditional Formatting in a Lollipop Chart in Excel

February 23, 2019March 8, 2025 PKComments Off on Conditional Formatting in a Lollipop Chart in Excel
Using the Conditional Formatting in a Lollipop Chart in Excel is very useful. It helps to audience to identify which category is meeting the target and which is not meeting.
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
Flag Chart
Charts and Visualization

Info-graphics: Flag Chart in Excel

February 16, 2019March 11, 2025 PKComments Off on Info-graphics: Flag Chart in Excel
If you have a small data set and you want to create an attractive chart then Flag chart is very nice Idea. It is very eye catching and innovative Idea.
Read More
Rating Meter
Charts and Visualization

Rating Meter Chart in Excel

January 2, 2019February 21, 2025 PK0
Rating Meter Chart in Excel is very innovative and informative chart to show the Process or Portfolio level health in five buckets – Worst, Bed, Average, Good and Best. This
Read More
Stylish Butterfly Chart
Charts and Visualization

Stylish Butterfly Chart – Version 2

December 12, 2018September 10, 2024 PK0
This is the version-2 of Stylish Butterfly Chart. In the “Stylish Butterfly Chart – Version 1”, we created it vertically. In this chart we will create the butterfly chart horizontally. 
Read More

Posts pagination

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