Charts and Visualization

Stylish Doughnut Charts in Excel

In this article you will learn how to create 4 stylish doughnut charts in Excel. These doughnut charts are used to display the KPI metrics or progress of a project. Stylish Doughnuts can be used to in business dashboard or business presentation. Below are the steps to create stylish doughnut charts in Excel- Doughnut Chart-1: Let's say we have a KPI metric on cell D1 and its performance value on
Multilayered Doughnut Chart-Part1
Charts and Visualization

Multilayered Doughnut Chart : Part-1

In this article you will learn how to create a beautiful multilayered Doughnut Chart for KPI metrics. In this chart we can display 3 or 4 KPI metrics at a time. This chart can be used in business presentations or dashboards. Below is the data set for which we will create multilayered Doughnut Chart. [caption id="attachment_3257" align="aligncenter" width="228"] Metrics data set[/caption] Below are the steps to create the multilayered Doughnut
VBA

VBA: Send Email With Outlook Mail body Snapshot

In this article you will learn how to send an Outlook Email with mail body snapshot like Excel tables, Charts or images by using VBA. We will use "Mail Envelope" method to sending the email. This method is quite easy and small. We have to create our data on a worksheet in email format and It will send the entire worksheet or selected range on outlook mail body. As in the
Dynamic Step Chart
Charts and Visualization

Dynamic Step Chart in Excel

In this article you will learn how to create a dynamic Step Chart in Excel. In this chart we can show the rolling 7 days price or sales. Let's say we have dates on column A ("1-Jan to 3-Feb") and sales on column B. For this data set we will create the dynamic step chart. [caption id="attachment_3159" align="aligncenter" width="244"] Data set for step chart[/caption] Below are the steps to create
Stunning-Battery-Chart
Charts and Visualization

Stunning Battery Chart

In this article you will learn how to create a stunning and beautiful battery chart in excel. You can use this battery chart in business dashboard or presentation to show the KPI metrics. Below are the steps to create this stunning battery chart- We will create this chart to Service Level metric. Put the service level actual value on Range "G1" Put the formula "=100%-G1" on cell "H1" [caption id="attachment_3131"
Text-Join-UDF
VBA

Text Join Formula for all Excel Versions

TEXTJOIN Function was introduced with the release of Excel 2016. This is very helpful function to join the multiple text into one. The best thing is that it allows us to select an entire range of cell references to be joined. So it is very time saving formula. But the problem is this formula is not available in lower versions of excel as 2013,2010 or in 2007 etc. Here I
RAG Conditional formatting in Progress Circle Chart
Charts and Visualization

RAG Conditional Formatting in Progress Circle Chart

In this article you will learn how to put RAG (Red, Amber and Green) conditional formatting in Progress Circle Chart in Excel. Progress Circle Chart is a beautiful circle chart which can be used to display KPI metrics. Color of the  Progress Circle chart will be changed as Red, Amber and Green according to the value of metric. Below is the screenshot of Service Level value and color range for
Gantt Chart in Excel
Charts and Visualization

Quick Gantt Chart

In this article you will learn how we can create a Gantt Chat quickly in Microsoft Excel. A Gantt Chart is used to show the project plan or project schedule. We will create this chart by using the horizontal Stacked Bar Chart. Position of the bar will display the Start Date of an activity. Length of the bar will display the duration of the activity. Below is the data set for