Create Multiple Names using VBA in Excel
Our daily Excel activities can be automated using VBA. Here we have created an example of Create Multiple Names using the Name range in Excel using VBA. Lets’ say we
Blogs
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
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
Horizontal Timeline Chart using Scatter chart in Excel
Project management is a complex task that involves multiple aspects, including planning, execution, control, and closure. Among the crucial elements of successful project management is the use of timeline charts,
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
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 %,
Insert a picture in Excel Comments
In this article, you will learn how to Insert a picture in Excel comments. Here I have taken the example for my popular Dashboards which are freely available to download.
UDF to Fetch Comment Text in Excel Cell
In this article, you will learn how to create a UDF to Fetch Comment Text in Excel Cell VBA to get the comment text from an Excel Cell. Let’s say we
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
Spotlight Visualization in Excel (Part-1)
This is the first part of Spotlight visualization in excel Here we have used RAG (Red, Amber and Green) color code to display metric performance like – Service Level, Quality Score