Dynamic Variance Arrows Chart with Slicers
In the previous article we create a Dynamic Chart with Variance Arrows using multiple check boxes. In this article, we have created the similar Dynamic Variance Arrows Chart with Slicers.
Blogs
Dynamic Variance Arrows Chart with Check Boxes
In this article, we have created a Dynamic Variance Arrows Chart with Check Boxes. This is quite useful chart to display the Sale variance in compare of previous year. We
UDF to get the frequency of specific word in a Paragraph
I. Introduction Data analysis - a critical aspect of modern business and organizations - provides valuable insights into various datasets, allowing informed decisions to be made. While Microsoft Excel boasts
Group of Circle Charts in Excel
Using the multiple Doughnut charts, we have created a beautiful Group of circle charts. In this chart, we have displayed Market level and Over all service level. You can use
Auto Bullet Points in Excel
In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting. To add the auto bullet point in excel range below are the steps-
Dynamic Chart with Form Control Scrollbar
In this article, we have created a Dynamic Chart with Form Control Scrollbar. If we have multiple dates in your data, then we can use scrollbar on the chart to
Word Cloud in Excel Using VBA
Word Cloud is also known as text cloud or tag cloud. Size of the words change according to the value or weightage or frequency of any word. Here we have
PDF to Excel Converter in Excel VBA
In this article, you will learn how to create a PDF to Excel converter using Excel VBA. We have created a Setting worksheet wherein we are taking 2 folders inputs
Forecast Vs Actual Chart with Safe Zone Range in Excel
In this article, we have created a Forecast Vs Actual Chart with Safe Zone Range. This is a very informative chart wherein you can display that your actual numbers are
Apply Same Format on other Charts
In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting