• Advanced Excel
    • 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
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Excel, VBA, and Power BI tutorials

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.

Quick Dynamic Sales by Employees chart with Slicers
Charts and Visualization

Quick Dynamic Sales by Employees chart with Slicer in Excel

March 16, 2023March 16, 2023 PKComments Off on Quick Dynamic Sales by Employees chart with Slicer in Excel
Excel is a powerful tool which can be used for a wide range of business applications, for analyzing data, creating charts and graphs etc. One useful feature in Excel is
Read More
Half Circle KPI
Charts and Visualization

Half Circle KPI Charts in Excel using Doughnut Charts

March 9, 2023March 9, 2023 PKComments Off on Half Circle KPI Charts in Excel using Doughnut Charts
Key Performance Indicators (KPIs) are metrics used to measure the success of a company or a particular project. KPIs can help businesses make informed decisions based on data, improve efficiency,
Read More
Waffle Chart with Football Icon-1
Charts and Visualization

Waffle chart with Football Icon in Excel

March 9, 2023March 9, 2023 PKComments Off on Waffle chart with Football Icon in Excel
Data visualization is important part of data analysis. It enables us to better understand the data, identify trends, and make informed decisions. There are several types of charts and graphs
Read More
Dynamically highlight topper student on the chart
Charts and Visualization

Dynamically highlight topper student chart

February 26, 2023March 11, 2023 PKComments Off on Dynamically highlight topper student chart
I. Introduction a. Explanation of what a dynamically highlight topper student chart is: A dynamically highlight topper student chart is a type of chart that highlights the student with the
Read More
Tornado or Butterfly chart
Charts and Visualization

Master the Art of Team Comparison with Tornado or Butterfly Charts in Excel

February 17, 2023February 17, 2023 PKComments Off on Master the Art of Team Comparison with Tornado or Butterfly Charts in Excel
Data visualization is a very important part of data analysis. Microsoft Excel offers a wide range of charts and graphs which can be useful to convey complex information in a
Read More
Truck Chart in Excel
Charts and Visualization

Truck Graph in Excel

February 7, 2023February 25, 2023 PKComments Off on Truck Graph in Excel
Excel is a powerful tool for creating a wide range of charts and infographics, including Truck Graph to show Occupancy or workload. In this blog post, we will look at
Read More
Symbols in Drop-down List and Charts
Charts and Visualization

Use of Symbols and Emojis in Excel Drop-down List and Excel Charts

January 15, 2023March 6, 2023 PKComments Off on Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
Microsoft Excel is widely used spreadsheet program data analysis and management. It allows you to perform complex calculations, create charts and graphs, and present data in a visually appealing way.
Read More
Quick 3D Container Chart
Charts and Visualization

Quick 3D Container chart in Excel

January 3, 2023January 3, 2023 PKComments Off on Quick 3D Container chart in Excel
In this article, we have created a beautiful 3D container chart in Microsoft Excel. We have used a 3D Stacked column chart to create this chart. You can use this
Read More
Quick Male-Female and Waffle Chart in Excel
Charts and Visualization

Quick Male-Female and Waffle Chart in Excel

October 20, 2022October 20, 2022 PKComments Off on Quick Male-Female and Waffle Chart in Excel
In this article, we have created two Waffle charts and a Male/Female infographic chart.  To create the waffle charts, we used the SEQUENCE function.   See our other related charts:
Read More
Charts and Visualization Templates

Weightage Analysis Template in Microsoft Excel

October 10, 2022October 10, 2022 PKComments Off on Weightage Analysis Template in Microsoft Excel
In this article, you will learn how to use Weightage Analysis in Microsoft Excel. Weightage Analysis is used to get the Weightage Score calculation based on different parameters.   In
Read More

Posts navigation

1 2 … 14 Next
  • Advanced Excel
    • 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
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy