• 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
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Pivot Chart

Daily Sales Dashboard
Dashboard

Daily Sales Dashboard in Excel

April 5, 2022April 5, 2022 PKComments Off on Daily Sales Dashboard in Excel
In this article, we have created a Daily Sales Dashboard to analyze the Daily Sales trends. We have displayed 4 metrics in this dashboard- # Of Calls: The number of
Read More
Cross Filter in Excel Chart
Charts and Visualization

Cross Filter Functionality in Excel Chart

July 5, 2021February 5, 2023 PKComments Off on Cross Filter Functionality in Excel Chart
Excel is a powerful tool that provides a wide range of features to help you analyze and present data effectively. One of the most key features in Excel is the
Read More
Pivot Chart Tips
Charts and Visualization

3 Useful Tips for the Pivot Chart

May 16, 2021May 16, 2021 PKComments Off on 3 Useful Tips for the Pivot Chart
In this article, you will learn 3 useful tips for Pivot Chart. Using these tips you can create an interactive Excel Dashboard. Learn and download interactive Excel Dashboard free of
Read More
Dynamic Comparison Analysis Chart
Charts and Visualization

Dynamic Comparison Analysis Chart in Excel

May 3, 2021May 3, 2021 PKComments Off on Dynamic Comparison Analysis Chart in Excel
In this article, you will learn how to create a dynamic comparison Analysis Chart in Microsoft Excel. Using this chart you can compare one employee's performance with other. We have
Read More
Ideas in Excel
Excel Tips and Tricks

Ideas in Excel

November 22, 2020November 22, 2020 PKComments Off on Ideas in Excel
In this article, we have explained how to use Ideas in Microsoft Excel. Ideas are used to get the suggestion and insights from your data. You can ask any question
Read More
Dynamic Filled Map
Charts and Visualization

Dynamic Filled map in Excel

August 23, 2020August 23, 2020 PKComments Off on Dynamic Filled map in Excel
In the article, You will learn how to create a dynamic filled map in Microsoft Excel. Filled Map is available with Office 365 subscription. You can display the Region, country,
Read More
Table view in Excel
Power BI VBA

Custom Toggle Button in Excel and Power BI

August 9, 2020August 9, 2020 PKComments Off on Custom Toggle Button in Excel and Power BI
In this article, we have created a custom toggle button in Microsoft Excel and Microsoft Power BI to toggle the Chart and Table on click of this toggle button. This
Read More
SUMX Function
Power Pivot

SUMX Function in Power Pivot

January 13, 2020January 13, 2020 PKComments Off on SUMX Function in Power Pivot
In this article, we have explained how to use Measure in Pivot Pivot data model. We have taken the example of SUMX function to calculate the revenue. On the base
Read More
Power Pivot

Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)

January 9, 2020January 9, 2020 PKComments Off on Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)
In this article, we have explained how to use calculated column in Power Pivot Data Model.  We have taken the example of Orders data wherein we have product level Unit
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

Posts navigation

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