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