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
Blogs
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
RYG Dial Gauge Meter in MS Excel
RYG Dial Gauge Meter in MS Excel is very attractive and useful visual created by our team. This visual can be used to display the KPI metrics Like Service Level,
How to use the picture effect in your chart
You can use the picture effects in your chart by using the Camera functionality or Linked Picture option available in Paste Special (Home tab). You can give the beautiful look
Conditional Formatting in Multiple Batteries Chart
Battery chart is a very nice visual to display a KPI metric. We can create the multiple batteries in a single chart. We can also use the conditional formatting in
Traffic Lights in MS Excel
Creating the Traffic lights in excel is genuinely nice idea to show the Performance Indicator. We have created this traffic light by using auto shapes then connected it with the
Balloon chart in MS Excel
Balloon chart in MS Excel is very attractive and innovative visual in excel created by my team. This visual can be used in place of a column chart. Height of