Group of Circle Charts
Charts and Visualization

Group of Circle Charts in Excel

Using the multiple Doughnut charts, we have created a beautiful Group of circle charts. In this Group of Circle Charts, we have displayed Market level and Over all service level. You can use it in your business dashboard or presentation. Below are the data points for which we have created this Group of Circle charts – [caption id="attachment_16550" align="aligncenter" width="262"] Data Set[/caption] Below is the snapshot of Group of Circle
Word Cloud
Charts and Visualization

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 created a macro to create the word cloud in Excel. In this macro file, we have 2 worksheets Setting Worksheet – In this worksheet, you need to enter your data, like we have entered the Country wise population. We have
Forecast Vs Actual Chart
Charts and Visualization

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 within the forecast range or not. We have below given data to create this chart- [caption id="attachment_15854" align="aligncenter" width="377"] Actual and Forecast data[/caption] We have created a below given chart where we have displayed – Forecast, Actual and Safe Zone
Dynamic Chart with Option buttons
Charts and Visualization

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 buttons rather than Slicer. We have created option buttons for departments. Whichever option button will be selected, it will display the data on the chart accordingly and Chart title also will be changed. Below is the data for multiple employees
Dynamic Chart with Slicer
Charts and Visualization

Dynamic Chart with Slicer for Employees Count by Age group

In this article, we have created a Pivot Chart to display the department wise employees count by different age groups. We have given a slicer for departments. Whichever department will be selected in the slicer, it will display the data on the chart accordingly and Chart title also will be changed. Below is the data for multiple employees with their age in years- [caption id="attachment_15419" align="aligncenter" width="467"] Employees Data[/caption] Below
Multiple KPI Visualization
Charts and Visualization

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 dynamically to display the KPI performance. This visualization can be used for any type of KPI data type like – Numbers, percentages or decimals etc. We have displayed below given sample KPIs on the visualization - [caption id="attachment_15053" align="aligncenter" width="194"]
Horizontal Timeline Chart
Charts and Visualization

Horizontal Timeline Chart using Scatter chart in Excel

In our previous article we created a Vertical Timeline Chart using Scatter chart. Here, we have created a Horizontal Timeline Chart using scatter chart in Excel. This is a dynamic chart. if you will add a new milestone in table, it will be reflected on the chart automatically. Below is the image of Horizontal Timeline Chart in Excel- [caption id="attachment_14872" align="aligncenter" width="1215"] Horizontal Timeline Chart[/caption] Click here to download the
Vertical Timeline Chart
Charts and Visualization

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 a dynamic Chart if you will add a new milestone in table, it will be reflected on the chart automatically. Below is the image of Vertical Timeline Chart in Excel- [caption id="attachment_14813" align="aligncenter" width="992"] Vertical Timeline Chart[/caption]   Click here
Waffle Chart
Charts and Visualization

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 %, Quality Score %, Sales conversion % or Project completion%. Here we have created 3 different Waffle Charts to display Service Level %, Quality Score %, Sales conversion% in Microsoft Excel. [caption id="attachment_14747" align="aligncenter" width="1140"] Waffle Charts in Excel[/caption] Click here
Spotlight Visualization
Charts and Visualization

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 sales and highlighted the team manager with the highest sales. Below is the data which we have used in this chart- [caption id="attachment_14259" align="aligncenter" width="609"] Data[/caption] We have created this chart in 2 variants. Below is the snapshot to variant-1.