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	Defines the target value. Must fall between minValue and maxValue.
Current Value	Displays the current value. Must fall between minValue and maxValue.
Min Value	Sets the minimum value. Must be less than maxValue.
Max Value	Sets the maximum value. Must be greater than minValue.
Show Label	(Optional) Displays value labels when selected. If selected, labels appear only if the cell has enough space.
Label Option	(Optional) Opens the GaugeKPISparkline Label Option dialog to customize label text and font. Applies only when Show Label is selected. 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	Sets the gauge type: Circle (default), Vertical bar, or Horizontal bar.
Min Angle	Sets 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	Sets the ending angle for circle-type gauges. Must be greater than Min Angle.
Radius Ratio	Sets the ratio between the inner and outer radius of a circular gauge (from 0 to 1). Applies only to circle-type gauges. Default is 0.
Style	Opens the GaugeKPISparkline Style Setting dialog to define color ranges: Start Value – Beginning of the range. Must be less than the end value and fall between the minimum and maximum values. End Value – End of the range. Must fall between the minimum and maximum values. Color – Fill color applied between the start and end values. The default range spans from Min Value to Max Value and uses light gray.