• 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: Form Controls

Highlight top N in Excel
Charts and Visualization

Highlight Top and Bottom N in Excel Chart

August 11, 2024October 14, 2024 PKComments Off on Highlight Top and Bottom N in Excel Chart
This is ready to use Chart to Highlight Top or bottom N in Excel Chart. You can use it for office use. This is a totally dynamic chart. Data: To
Read More
Top Employees Dynamic Chart by GROUPBY and TAKE
Charts and Visualization

Dynamic chart for Top Selected Employees with GROUPBY and TAKE function

February 4, 2024June 12, 2024 PKComments Off on Dynamic chart for Top Selected Employees with GROUPBY and TAKE function
In today's fast-paced business environment, visual data representation has become an indispensable tool for decision-making and performance analysis. One effective way to visually represent your data is through dynamic charts.
Read More
Magic Search Bar in Excel
Templates

Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!

August 1, 2023March 18, 2025 PKComments Off on Unlock Excel Secrets: Magic Search Bar You NEVER Knew About!
Welcome Excel enthusiasts! If you are always on the lookout for nifty Excel tips and tricks that can help you work smarter, you're in the right place. Today we delve
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
Tablet and Mobile layout Dashboard
Dashboard

Dynamic Dashboard with Tablet and Mobile shape in Excel

May 17, 2020February 28, 2025 PKComments Off on Dynamic Dashboard with Tablet and Mobile shape in Excel
In this article, we have created an attractive and dynamic dashboard using Tablet and Mobile shape. We have created Tablet and Mobile shapes using Excel Shapes. We have made the
Read More
Sales Score meter Chart -V2
Charts and Visualization

Dynamic Sales Score Meter Chart

April 19, 2020February 23, 2025 PKComments Off on Dynamic Sales Score Meter Chart
In this article, we have created a dynamic sales score meter chart. In this chart we have displayed the sales core on a speedometer chart. We have displayed the sales
Read More
Dynamic Chart with Form Controls
Charts and Visualization

Fully dynamic chart in Excel with Scroll bar and Spin button

March 19, 2020March 3, 2025 PKComments Off on Fully dynamic chart in Excel with Scroll bar and Spin button
Are you ready to unleash the full potential of Excel's data analysis and visualization capabilities? Hold on tight, because we're diving into the mysterious realm of creating a fully Fully
Read More
Dynamic Performance Chart
Charts and Visualization

Dynamic Performance Chart in Excel

November 7, 2019March 3, 2025 PKComments Off on Dynamic Performance Chart in Excel
In this article, we have created dynamic Performance Charts. We have used excel shapes and Doughnut Chart here. To make these charts dynamic we have used Form control option buttons. Dynamic
Read More
Dynamic Conditional Formatting
Charts and Visualization

Dynamic Conditional Formatting in Excel

October 10, 2019March 6, 2025 PKComments Off on Dynamic Conditional Formatting in Excel
In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights
Read More
Dynamic Variance Arrows Chart with Check Boxes
Charts and Visualization

Dynamic Variance Arrows Chart with Check Boxes

August 27, 2019March 10, 2025 PKComments Off on Dynamic Variance Arrows Chart with Check Boxes
In this article, we have created a Dynamic Variance Arrows Chart with Check Boxes. This is quite useful chart to display the Sale variance in compare of previous year. We
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