• 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 V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • 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
  • Consulting ServicesPopular
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Dynamic Chart

Tablet and Mobile layout Dashboard
Dashboard

Dynamic Dashboard with Tablet and Mobile shape in Excel

May 17, 2020May 17, 2020 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
Dynamic Chart with Form Controls
Charts and Visualization

Fully dynamic chart in Excel with Scroll bar and Spin button

March 19, 2020February 5, 2023 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 dynamic
Read More
Medical Science Info-graphic Chart
Charts and Visualization

Medical Science Info-graphic Chart in Excel

February 23, 2020February 23, 2020 PKComments Off on Medical Science Info-graphic Chart in Excel
In this article, we have created a beautiful Medical Science info-graphics chart in Excel. We have displayed department wise blood donation% using this info-graphic in excel only. We have not
Read More
3D Visualization in Excel
Charts and Visualization

Beautiful 3D Visualization in Excel

February 9, 2020February 9, 2020 PKComments Off on Beautiful 3D Visualization in Excel
In this article, we have created a beautiful 3D visualization in Excel using 3D Column charts and Excel Shapes. You can use this visualization in your business dashboard or business
Read More
Drill Down in Pivot Chart
Charts and Visualization Power Pivot

Drill Down/Drill Up Feature in Pivot Chart

January 6, 2020January 6, 2020 PKComments Off on Drill Down/Drill Up Feature in Pivot Chart
In this article, we have created a drill down/drill up functionality in a Pivot chart. We have created a hierarchy in Power Pivot data model to create this. Below are
Read More
Dynamic Variance Arrow Chart with Slicer
Charts and Visualization

Dynamic Variance Arrows Chart with Slicers

August 29, 2019August 29, 2019 PKComments Off on Dynamic Variance Arrows Chart with Slicers
In the previous article we create a Dynamic Chart with Variance Arrows using multiple check boxes. In this article, we have created the similar Dynamic Chart with Variance Arrows using
Read More
Dynamic Variance Arrows Chart with Check Boxes
Charts and Visualization

Dynamic Variance Arrows Chart with Check Boxes

August 27, 2019August 27, 2019 PKComments Off on Dynamic Variance Arrows Chart with Check Boxes
In this article, we have created a Dynamic Chart with Variance Arrows using multiple check boxes. This is quite useful chart to display the Sale variance in compare of previous
Read More
Dynamic Chart with Scroller
Charts and Visualization

Dynamic Chart with Form Control Scrollbar

August 13, 2019August 13, 2019 PKComments Off on Dynamic Chart with Form Control Scrollbar
In this article, we have created a Dynamic Chart with Form Control Scrollbar. If we have multiple dates in your data, then we can use scrollbar on the chart to
Read More
Dynamic Chart with Option buttons
Charts and Visualization

Dynamic Chart with Option Button for Employees Count by Age group

July 22, 2019July 22, 2019 PKComments Off on Dynamic Chart with Option Button for Employees Count by Age group
In our last article, we created a Dynamic Chart with Slicer for Employees Count by Age group. Now in this article, we have created same chart with Form Control Option
Read More
Dynamic Chart with Slicer
Charts and Visualization

Dynamic Chart with Slicer for Employees Count by Age group

July 17, 2019February 7, 2023 PKComments Off on Dynamic Chart with Slicer for Employees Count by Age group
Data analysis is an essential aspect of any business. It helps to make informed decisions based on evidence and trends. One of the ways to present data is through charts,
Read More

Posts navigation

Previous 1 2 3 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 V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • 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
  • Consulting ServicesPopular
  • 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