Chart and Visualization Archives

How to WOW Your Boss: 3D Progress Circle in Excel

August 28, 2023August 28, 2023 PKComments Off

In today's fast-paced digital world, it's not just about delivering information, but more importantly, how you present it. Consequently, stepping away from conventional presentation methods is essential. For this reason,

Charts and Visualization

Dynamic KPI indicator with SEQUENCE and CEILING Function in Excel

April 18, 2023April 18, 2023 PKComments Off

In the competitive landscape of today's business world, tracking and analyzing key performance indicators (KPIs) is vital for assessing and improving your organization's performance. Microsoft Excel provides various functions to

Dynamically highlight topper student on the chart

Charts and Visualization

Dynamically highlight topper student chart

February 26, 2023March 11, 2023 PKComments Off

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

Charts and Visualization

Truck Graph in Excel

February 7, 2023February 25, 2023 PKComments Off

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

Charts and Visualization

Quick 3D Container chart in Excel

January 3, 2023January 3, 2023 PKComments Off

In this article, we have created a beautiful 3D container chart in Microsoft Excel. We have used a 3D Stacked column chart to create this chart. You can use this

Charts and Visualization Templates

Weightage Analysis Template in Microsoft Excel

October 10, 2022October 10, 2022 PKComments Off

In this article, you will learn how to use Weightage Analysis in Microsoft Excel. Weightage Analysis is used to get the Weightage Score calculation based on different parameters. In

VBA

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

August 16, 2022August 16, 2022 PKComments Off

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

Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022July 12, 2022 PKComments Off

In this article, we have created multi-color data bars in Excel cells using REPT function. We have used the conditional formatting to change the color based on certain criteria.

Charts and Visualization

Sales Analysis Heat Map by Time and Day

March 27, 2022March 27, 2022 PKComments Off

In this article, we have created a dynamic Sales Analysis Heat Map by Time and Day. Using this analysis, you will get to know your most busy time in a

Charts and Visualization

Double Doughnut Chart in Excel

February 28, 2022 PKComments Off

In this article, you will learn how to create a Double Doughnut Chart in Excel. In the outer layer of doughnut, we are displaying the Days name and in the