Pine BI - Actual Vs. Target Charts

Simple Bullet 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

Full Overlap 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

Partial Overlap 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

Thermometer 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

Column Chart With Markers

  • ​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 with Point and Line Markers

Column Chart Dynamic Colors

The color of the bars changes based on whether the Actual result has reached the Target or not.

  • ​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 with both Higher the Better (Up) and Lower the Better (Down) options

Line Threshold Chart

The color of the bars changes based on whether the Actual result is between the Threshold lines.

  • ​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 with both Higher the Better (Up) and Lower the Better (Down) options

Area Threshold Chart

The color of the bars changes based on whether the Actual result is in the Threshold Area or not.

  • ​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 with both Higher the Better (Up) and Lower the Better (Down) options

Copyright © 2018 - 2020 PINEXL Ltd.