Infographics is the use of  images/icons to represent your data. They help to capture the users attention and also give a creative feel to your data.Infographics in Excel Charts make it visually appealing .

For e.g : We have a data based on an employee engagement survey.

The employee engagement % values for men and women are shown.

The chart is good. It gives you the required information. But imagine a dashboard wherein you have multiple column charts and bar charts. This chart would be just another chart to the mix.

So to enhance your data representation you need to apply infographics.

Now what is infographics. It is showing of information via images.

So the same chart above using infographics is shown below.

The image fill amount is determined by the respective % values.

As the percent changes the image fill for the respective image as changes. See below

Download Template _Infographics_Employee Engagement

In this example we have the monthly sales data.We have two combo box denting the from date and to date.

The resultant chart represents sales data for the selected period.

If the user selects a From Month which is after the To Month.

In this scenario, the resultant chart will show sales for the entire year( January to December).

Download Chart From Date -To Date

There are two variants of this chart

• Highlighting the year with maximum attrition
• Highlighting the selected year.

The user can adopt this chart and create more variations like years having above attrition highlighted or separating a yearly attrition across departments /locations and then highlighting the department/location with highest attrition.

Download-File-Line-Attrition

In our example, we have the manpower data for 14 years across 5 locations.

We have created 2 charts and a data table from the above data.

A scroll bar is used to regulate the years.As we click through the scroll bar the year selected will change.

Sliding towards the right will increase the years and clicking the left indicator will decrease the year.

Clicking the mid indicator (left or right) will also increase /decrease the value.

The resultant chart will be as below:

Donut Chart + Column Chart

We will also have a data table which will show the resultant year data in a tabular format.

Download Column Donut Chart

In our example we have the actual and budget values for a year. A positive scenario is when we are within budget and a negative scenario is when we are above budget.

• Positive scenario: Green
• Negative scenario: Red
• Budget values : Light blue.

This chart can be used for situations like sales vs target, last month values vs current month values.

Download Chart_Actual_Budget

Employee survey, Employee Satisfaction, Product Rating generally use a five point scale.

• 1 Star : Poor
• 2 Star : Below Average
• 3 Star : Average
• 4 Star : Good
• 5 Star : Excellent

The same is created in an excel chart using combo boxes.

Dashboard Star Rating

A Butterfly Chart (also called a Tornado chart) is used to compare two sets of data that have similar metrics. In this chart two bar charts are displayed side by side to analyse the difference between two data series and the data categories are listed vertically instead of the standard horizontal presentation.

It is called as butterfly since there is a gap in the centre which denotes the categories and the bars on either side resemble the wings of a butterfly.

As the bars on either side vary in length due to data values of the corresponding data series, it is also called Tornado chart.

The main use of the butterfly chart is comparison of two data sets sharing the same parameters.

e.g

• Population Chart ( males vs females)
• Survey Results (Yes vs No)
• Product Sales ( Location A vs Location B)
• Department Headcount ( Joinee vs Resignee)

In our example we are using the Butterfly Chart to denote the joiners / resignees across department.

Download Template Butterfly or Tornado Chart