Show Hidden/Collapsed Cells data on the Chart
In this article, you will learn how to display Show Hidden/Collapsed Cells data on the chart. if we create a chart for month wise sales and hide or collapse few
Blogs
Quick Re-Arrange Columns Sequence Using Data Sorting
In this article, you will learn how to sort the data by columns. If you have multiple columns in your excel sheet and you want to arrange the order of
Dynamic Chart with Option Button for Employees Count by Age group
In our last article, we created a Dynamic Chart with Slicer for Employees Count by Age group. Now in this article, we have created same chart with Form Control Option
Dynamic Chart with Slicer for Employees Count by Age group
Data analysis is an essential aspect of any business. It helps to make informed decisions based on evidence and trends. One of the ways to present data is through charts,
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
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
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