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.

Copyright © 2018 - 2020 PINEXL Ltd.