Pine BI - Actual Vs. Target Charts

Simple Bullet Chart
AvT Bullet.jpg

  • ​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
AvT Overlap.jpg

  • ​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
AvT P Overlap.jpg

  • ​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
AvT Thermometer.jpg

  • ​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
AvT Marker.jpg

  • ​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
AvT DC.jpg

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
AvT T Line.jpg

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
AvT T Area.jpg

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