Variance analysis refers to a difference between two values. The deviation may favorable or unfavorable as under:

Variance is generally calculated as per below parameters

The time period for measuring deviation can be as under:

• Current Month vs Previous Month
• Current Year vs Previous Year
• First Quarter vs Second Quarter

Variance Reports are made to find out the % increase or decrease for Profit, Revenue, Cost Expenses, Attrition, Manpower Count, Salary, Recruitment Cost etc.

Examples of Variance Analysis charts

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