Gauge KPI Sparklines

A gauge KPI sparkline is a small, speedometer-style chart that shows progress toward a goal. It uses a needle to indicate the current value and color-coded zones (such as green, yellow, or red) to show performance levels.

When to use gauge KPI sparklines

• Tracking performance against a target: Indicate how a metric compares to a predefined goal, such as sales figures, revenue, or completion rates.
• Providing quick visual feedback: Show whether performance is meeting, exceeding, or falling short of expectations using color‑coded zones.
• Monitoring key metrics in dashboards: Display multiple KPIs in a compact format that fits easily within a dashboard layout.

Create a gauge KPI sparkline

1. On the Insert tab, select Sparklines.
2. Under Other Sparkline, select Insert GaugeKPI Sparkline. The GaugeKPISparkline Setting dialog opens.
3. Set the parameters.
4. Click Ok.

Edit a gauge KPI sparkline

1. Select the gauge KPI sparkline in your workbook.
2. On the Sparklines tab, select Settings. The GaugeKPISparkline Setting dialog opens.
3. Adjust the parameters, then click Ok.
4. Copy and paste the cell as needed to finalize your Gauge KPI sparklines.

Gauge KPI sparkline parameters

The gauge KPI sparkline formula supports the following format:

=GAUGEKPISPARKLINE(targetValue, currentValue, minValue, maxValue, showLabel?, targetValueLabel?, currentValueLabel?, minValueLabel?, maxValueLabel?, fontArray?, minAngle?, maxAngle?, radiusRatio?, gaugeType?, colorRange?)

Parameter	Description
Target Value	Define the target value. Must be between minValue and maxValue.
Current Value	Define the current value. Must be between minValue and maxValue.
Min Value	Set the minimum value. Must be less than maxValue.
Max Value	Set the maximum value. Must be greater than minValue.
Show Label	(Optional) Display value labels. Labels appear only if the cell has sufficient space.
Label Option	(Optional) Open the GaugeKPISparkline Label Option dialog to customize label text and font. Available only when Show Label is enabled. Each label uses a CSS-style font string. Default styles: Target Value Label – 16px, Calibri Current Value Label – 22px, Calibri, bold Min Value Label – 12px, Calibri Max Value Label – 12px, Calibri
Graph Type	Set the gauge type: Circle (default), Vertical bar, or Horizontal bar.
Min Angle	Set the starting angle for circle-type gauges. Must be less than Max Angle. Common values: 0 – 12 o'clock -90 – 9 o'clock (default) 90 – 3 o'clock -180 / 180 – 6 o'clock
Max Angle	Set the ending angle for circle-type gauges. Must be greater than Min Angle.
Radius Ratio	Set the ratio between the inner and outer radius of a circular gauge. Value range: 0 to 1. Applies only to circle-type gauges. Default: 0.
Style	Open the GaugeKPISparkline Style Setting dialog to define color ranges: Start Value – Define the beginning of the range. Must be less than the end value and within the minimum and maximum range. End Value – Define the end of the range. Must be within the minimum and maximum range. Color – Set the fill color applied between the start and end values. Default range: Min Value to Max Value using light gray.