3D KPI Indicator in Excel
Several times we have to show the some indicator of our KPI metrics to indicate that particular metrics is in Red, Yellow or Green. 3D KPI Indicator in Excel Here
Blogs
Filling Stacked Column Chart in Excel
Today I have come with a beautiful Filling Stacked Column Chart. In this chart I have showcased day wise Sales Conversion. There are 5 circles for 100% each for 20%.
Dynamic Project Planner (Gantt Chart) in Excel
Here we have created a beautiful and dynamic Project Planer (Gantt chart) in Excel. We have given a drop-down to change the weekly and daily view. There are 3 type
VBA: Filter Data with Multiple Values
In this article you will learn how we can use an excel range as a filter criteria and paste the filtered data on another worksheet VBA: Filter Data . For
User Defined Function for Sub-strings count from Excel Cell
We often need the count of sub-strings from out text available in Excel. For example we have comma separated ticket number in a cell and we have to count how
Lock Excel Cell after Updating
One of our client asked us to create a template wherein data can entered only once. As soon as data is entered in the cell, it should be locked for
Excel Template with Protection and Validation
We often required an Excel Template to send some persons or teams so that they can enter the data in the template and can sent it to us and then
Info-graphics with Column chart (Part-2)
In this article you will learn how we can use info-graphics in the column chart for KPI metrics. We have created 4 different charts for Service Level. These charts can
Info-graphics with Column chart (Part-1)
Using the info-graphics in the charts is very nice idea. It will increase the visual appeal and audience attention of your report or dashboard. We have created 4 different charts
Info-graphics with Line Chart
Line charts, as an efficient means of tracking and showcasing data trends over time, have become a go-to solution for visualizing metrics such as sales, revenue, and others. In this