Dynamic Number Format
Excel Tips and Tricks

Dynamic Number Format for Millions and Thousands

Many times, when we create a chart and our numbers are quite big then our data labels on the chart are not proper readable. In that case we can change the number format of data label of the charts in millions or thousands according to our numbers. To change the number format of data labels just right click on Chart and click on Format data labels. Go to the numbers
Name Manager
Uncategorized VBA

Create Multiple Names using VBA in Excel

Our daily Excel activities can be automated using VBA. Here we have created an example of creating the Name range in Excel using VBA. Lets’ say we have below given data for which we have create the Names- [caption id="attachment_15185" align="aligncenter" width="1131"] Data to create the Names[/caption] We have created a button on the Home tab and assigned the macro on this button. [caption id="attachment_15183" align="aligncenter" width="559"] Additional button added
Multiple KPI Visualization
Charts and Visualization

Multiple KPIs Visualization in Excel

We have created an attractive visualization to display multiple KPI performance in Excel. We have used Excel auto shapes to create this visualization. RAG (Red, Amber, and Green) color changes dynamically to display the KPI performance. This visualization can be used for any type of KPI data type like – Numbers, percentages or decimals etc. We have displayed below given sample KPIs on the visualization - [caption id="attachment_15053" align="aligncenter" width="194"]
Birthday Count
Excel Tips and Tricks

Highlight and get birthdays count from Date of Birth

In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how to highlight the data using Conditional Formatting whose birthdays are in This Month, Last Month and Next Month. We have below given Date of Birth data for Employees- [caption id="attachment_14951" align="aligncenter" width="435"] Date of Birth data[/caption] We have created a
Horizontal Timeline Chart
Charts and Visualization

Horizontal Timeline Chart using Scatter chart in Excel

In our previous article we created a Vertical Timeline Chart using Scatter chart. Here, we have created a Horizontal Timeline Chart using scatter chart in Excel. This is a dynamic chart. if you will add a new milestone in table, it will be reflected on the chart automatically. Below is the image of Horizontal Timeline Chart in Excel- [caption id="attachment_14872" align="aligncenter" width="1215"] Horizontal Timeline Chart[/caption] Click here to download the
Vertical Timeline Chart
Charts and Visualization

Vertical Timeline Chart using Scatter chart in Excel

A timeline chart is an effective way to visualize the different Milestones of a Project. Here we have created a Vertical Timeline Chart using Scatter Chart in Excel. This is a dynamic Chart if you will add a new milestone in table, it will be reflected on the chart automatically. Below is the image of Vertical Timeline Chart in Excel- [caption id="attachment_14813" align="aligncenter" width="992"] Vertical Timeline Chart[/caption]   Click here
Waffle Chart
Charts and Visualization

Waffle Charts in Excel Without Macro

The Waffle Chart is an attractive 10x10 grid in which each cell represents one percentage point. You can use this chart to display your KPI metrics like Service Level %, Quality Score %, Sales conversion % or Project completion%. Here we have created 3 different Waffle Charts to display Service Level %, Quality Score %, Sales conversion% in Microsoft Excel. [caption id="attachment_14747" align="aligncenter" width="1140"] Waffle Charts in Excel[/caption] Click here
Picture in Comments box
Excel Tips and Tricks

Insert a picture in Excel Comments

In this article, you will learn how to insert a picture in comments. Here I have taken the example for my popular Dashboards which are freely available to download. I have created a table of Dashboards, Youtube tutorial link and Free download link as given in the below image. [caption id="attachment_14560" align="aligncenter" width="1096"] Excel Table[/caption] I have added the comments for each dashboard and inserted the picture of the dashboard
Get Comments UDF
VBA

UDF to Fetch Comment Text in Excel Cell

In this article, you will learn how to create a User-defined function in VBA to get the comment text from an Excel Cell. Let’s say we have attendance data on the Excel sheet and We are putting comments for the absent employees. Now if we need to fetch these comments in Excel cell to do some analysis then we can use this UDF. [caption id="attachment_14475" align="aligncenter" width="699"] Get Comments UDF[/caption]
Spotlight Visualization
Charts and Visualization

Spotlight Visualization in Excel (Part-2)

This is the second part of Spotlight visualization. Here we have used spotlight to highlight top performer in the chart. We have created a Column Chart for Team Manager wise sales and highlighted the team manager with the highest sales. Below is the data which we have used in this chart- [caption id="attachment_14259" align="aligncenter" width="609"] Data[/caption] We have created this chart in 2 variants. Below is the snapshot to variant-1.