Pine BI | Actual Vs Target Charts

top of page

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

bottom of page