Highlight the Specific data point in a Line Chart Dynamically
In this chart we have explained how to Highlight the Specific data point in a Line Chart Dynamically. You can highlight the Minimum, Maximum and Selected data points in a
Blogs
Info-graphics: Animated Hour Glass Chart in Excel
Animated Hour Glass Chart in Excel has been designed to display the KPI metrics like – Service Level, Quality Score, and Productivity etc. Whenever the value of metric will be
An Innovative chart for team level performance
This innovative and eye-catching chart, we have created a chart for team level performance using Line with Marker chart. In this chart we have displayed seven teams and their performance.
VBA: User form Validation for Mobile Number input
While create the Data Entry form in VBA, We need to put some validation in text boxes and combo boxes. In this article you will how we can put the
Highlight Top and Bottom Performer using conditional formatting
In this article you will learn how to use Conditional Formatting to Highlight Top and Bottom performer on the base of performance score. Top performer has been highlighted in green
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
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