• 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: Column Chart

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
Conditional formatting in Excel Chart
Charts and Visualization

Conditional formatting in Excel Chart

May 3, 2022 PKComments Off on Conditional formatting in Excel Chart
In this article, you will learn how to use Conditional formatting in Excel Chart. You can use this trick to show to Target Vs Actual number.   [caption id="attachment_57797" align="alignnone"
Read More
Beer Mug Chart
Charts and Visualization

Beer Mug Graph in excel

March 3, 2022 PKComments Off on Beer Mug Graph in excel
Beer mug chart is a beautiful infographic representation for KPI metrics in percentage like - Target Achieved%, Service Level%, Quality Score etc. [caption id="attachment_56543" align="alignnone" width="1003"] Beer Mug Chart[/caption] Learn
Read More
Day Wise Service Level Chart
Charts and Visualization

Stylish Column Chart in Excel

November 7, 2021November 7, 2021 PKComments Off on Stylish Column Chart in Excel
In this article, we have created a Stylish Column Chart in Microsoft Excel. You can use this info-graphic chart in your Excel Report or Business Dashboard. We have displayed Day
Read More
10 Pro Tips for Excel Charts
Charts and Visualization

10 Pro Tips for Excel Charts

January 10, 2021February 15, 2022 PKComments Off on 10 Pro Tips for Excel Charts
In this article, you will learn 10 Pro tips for Excel Chart. Using these tips, you can improve your productivity and visualization skill set in Excel. Below is the list
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
Apply-Chart-Format
Excel Tips and Tricks

Apply Same Format on other Charts

July 29, 2019July 29, 2019 PKComments Off on Apply Same Format on other Charts
In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting
Read More
display hidden data on the chart
Excel Tips and Tricks

Show Hidden/Collapsed Cells data on the Chart

July 26, 2019July 26, 2019 PKComments Off on Show Hidden/Collapsed Cells data on the Chart
In this article, you will learn how to display hidden data on the chart. if we create a chart for month wise sales and hide or collapse few months then
Read More

Posts navigation

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