• 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

Tag: Auto shapes

Charts and Visualization

Truck Graph in Excel

February 7, 2023March 2, 2025 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 the
Read More
Make Same Size of Shapes
VBA

Make same size of selected shapes/Charts/Pictures using single click

August 16, 2022April 9, 2024 PKComments Off on Make same size of selected shapes/Charts/Pictures using single click
In this article, we have created a macro to make the same size of the selected shapes, charts, or pictures. It will change the size accordingly to first object in
Read More
10 Super Tips in Excel
Excel Tips and Tricks

10 Super Tips in Microsoft Excel

October 4, 2020August 28, 2024 PKComments Off on 10 Super Tips in Microsoft Excel
In the article, you will learn 10 super tips in Microsoft Excel. You can improve you productivity in Excel using these tips- Learn 10 Pivot table useful tips- 10 Super
Read More
Table view in Excel
Power BI VBA

Custom Toggle Button in Excel and Power BI

August 9, 2020August 30, 2024 PKComments Off on Custom Toggle Button in Excel and Power BI
In this article, we have created a custom Toggle Button in Excel and Power BI to toggle the Chart and Table on click of this toggle button. This trick could be
Read More
Smart Chart with Condition Formatting
Power Pivot Charts and Visualization

Smart Chart with Laptop Shape in Excel

May 3, 2020March 3, 2025 PKComments Off on Smart Chart with Laptop Shape in Excel
In this article, we have created a beautiful and smart chart with Conditional formatting in Microsoft Excel. We have create a laptop shape also using Excel shapes. We have placed
Read More
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
Digital Clock
VBA Excel Tips and Tricks

Innovation: Digital Clock in Excel

December 16, 2018April 11, 2024 PK0
This time we have developed an innovative and stunning Digital Clock in Excel. We have created this using Excel auto shapes and VBA. Digital Clock in Excel [caption id="attachment_7136" align="aligncenter"
Read More
Informative KPI Indicator
Charts and Visualization

Informative KPI Indicator Chart (Version-1)

November 30, 2018March 11, 2025 PK0
I am back with one more stunning and Informative KPI Indicator Chart. In this chart I have used a RAG color pallet in 10 slices (10% each). Here I have
Read More
Slide Meter Chart
Charts and Visualization

Slide Meter Chart – Version 1

November 4, 2018March 6, 2025 PK0
Slide Meter Chart is very useful and eye catching chart to show the KPI metrics performance. This chart has been designed with the help of Column Chart, Line Chart and
Read More
Animated Hour Glass Chart
Charts and Visualization

Info-graphics: Animated Hour Glass Chart in Excel

October 28, 2018March 8, 2025 PK0
Animated Hour Glass Chart in Excel has been designed to display the KPI metrics like – Service Level, Quality Score, and Productivity etc. Whenever the value of metric will be
Read More

Posts pagination

1 2 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