Gauges & MetersHow to add alerts in a gauge? Prepare your data in your worksheet, you need:- a minimum value
- a maximum value
- a color for each alert.
Select the gauge in which you want alerts Click on the “SET PARAMETERS” button in the BeGraphic’s ribbon. Set up BeGraphic by filling the “Alert 1/2" & “Alert 2/2” tabs. To do so, link BeGraphic to cells defining the min, max and color for each alert.
Repeat the second action (
2) by selecting “Alert N°2” and/or “Alert N°3” (
3).
(
4) gives you the opportunity to customize the alerts by offering different positions and thickness in the gauge.
(
5) “C1” to “C6” define the position of the alerts in the gauge.
You can decide to have larger alerts by selecting a combination of positions (e.g.: “C1+C2”).
Once you have chosen all the option concerning alerts, you can click on the “Validate all” button (
6).
Examples of using options in the “Alert 2/2” tab:
Example of a dynamic dashboard in ExcelTo reach an example in BeGraphic:
1. Inside the BeGraphic ribbon, click on the last button called "Example and Help" to reach the demo collection.
2. In the first sub-menu "Example of usage", pick the "United Kingdom demo" map.