Pine BI - Variance Charts
Column/Bar Variance Chart
​
-
​Select the chart you want to add
-
Select the range with the Actual Results
-
Select the range with the Target
-
Can be created from normal cells, tables and Pivot Tables
-
Data Range can both horizontal or vertical
-
Template available
-
Available as Column and Bar Charts
-
Available with both Higher the Better (Up) and Lower the Better (Down) options
-
Variance values are absolute
Variance Pin/Lollipop Chart
​
-
​Select the chart you want to add
-
Select the range with the Actual Results
-
Select the range with the Target
-
Can be created from normal cells, tables and Pivot Tables
-
Data Range can both horizontal or vertical
-
Template available
-
Available as Column and Bar Charts
-
Available with both Higher the Better (Up) and Lower the Better (Down) options
-
Variance values are displayed as percentage
Advanced Variance Chart V1 (Excel 2013+)
​
-
​Select the chart you want to add
-
Select the range with the Actual Results
-
Select the range with the Target
-
Can be created from normal cells, tables and Pivot Tables
-
Data Range can both horizontal or vertical
-
Template available
-
Available as Column and Bar Charts
-
Available with both Higher the Better (Up) and Lower the Better (Down) options
-
Works best with Excel 2013 or newer. Older versions will not be able to show the data labels and may prompt and error.
Advanced Variance Chart V2 (Excel 2013+)
​
-
​Select the chart you want to add
-
Select the range with the Actual Results
-
Select the range with the Target
-
Can be created from normal cells, tables and Pivot Tables
-
Data Range can both horizontal or vertical
-
Template available
-
Available as Column and Bar Charts
-
Available with both Higher the Better (Up) and Lower the Better (Down) options
-
Works best with Excel 2013 or newer. Older versions will not be able to show the data labels and may prompt and error.