Pine BI - Gauges
Donut Chart
-
Select the chart you want to add.
-
Select the range with the Actual result
-
Data can be from normal cells, Tables or Pivot Tables
-
Template available
-
The Dynamic Color version is preset to have three levels - <80% (red), between 80% and 90% (yellow) and over 90% (green). The levels can be changed from the calculations by simply changing the value.
Speedometer V1
​​
-
Select the chart you want to add.
-
Available as Template only
-
Adjustable Target
-
Adjustable Pointer Width
​
-
The Dynamic Color version is preset to have three levels - <80% (red), between 80% and 90% (yellow) and over 90% (green). The levels can be changed from the calculations.
-
To change the colors, first deselect the Target Data Series from the Select Data menu.
Speedometer V2
​
-
Select the chart you want to add.
-
Available as Template only
-
Adjustable Target
-
Adjustable Pointer Width
​
-
The Dynamic Color version is preset to have three levels - <80% (red), between 80% and 90% (yellow) and over 90% (green). The levels can be changed from the calculations.
-
To change the colors, first deselect the Target Data Series from the Select Data menu.
Speedometer V3
​
-
Select the chart you want to add.
-
Available as Template only
-
Adjustable Levels Values (Column Levels)
-
Adjustable Data Labels (Column Labels)
-
Adjustable Pointer Width
-
A chart with custom amount of Levels can be created
-
To change the colors, first deselect the Pointer and Labels Data Series from the Select Data menu.
