Chart & Visualization Issues

How to Change the Value Range of an Excel Gauge Chart

Huma Ashraf ChHuma Ashraf Ch Nov 2, 2026 869 views

Question details

The user wants to adjust an Excel gauge chart to display a custom range (such as 50% to 100%) rather than the standard 0% to 100% scale.

How to Change the Value Range of an Excel Gauge Chart
Product
Excel
Device & OS
not provided
Scenario
Creating custom data visualizations or dashboards where the target data only falls within a specific high-percentage range.
Observed behavior
The default gauge chart displays a full 0% to 100% scale, which wastes visual space when data values only fluctuate within a smaller interval like 50% and 100%.
Before you start

Ensure your base data values and target metrics are clearly defined in your spreadsheet. You will need to create helper columns to normalize the data before updating your chart series.

Solution 1Recommended

Normalize Formulas for a Custom Gauge Chart Scale

Adjust your chart's source data formulas to calculate values relative to the new 50%–100% interval.

Because Excel does not have a native Gauge Chart type, gauges are typically built using a combination of Doughnut and Pie charts. To change the visual scale, you must mathematically adjust the values feeding the chart slices rather than just changing axis settings.

1
Define the New Minimum and Maximum

In a blank section of your sheet, enter your new scale limits. For example, set 50% as your Minimum and 100% as your Maximum.

2
Calculate the Range Interval

Subtract the Minimum from the Maximum (100% - 50% = 50%). This represents the total visual span of your new gauge background.

3
Normalize the Pointer Value

Create a formula to calculate the pointer's position relative to the new scale. Use the formula =(Actual Value - Minimum) / (Maximum - Minimum). For example, if your value is in cell A1, use =(A1 - 50%) / (100% - 50%).

4
Update Chart Data Series

Right-click your existing gauge chart, select 'Select Data', and replace the previous source data ranges for your background scale and pointer series with these new normalized values.

Consistency is Key: Apply the exact same start value and range calculation formulas to any other gauge charts in your dashboard to ensure uniform scaling across your entire report.
Customize Charts Easily

Build Custom Gauge Charts using WPS Spreadsheet

WPS Spreadsheet offers powerful formula calculation and flexible chart customization tools, allowing you to easily build and adjust advanced visualizations like custom-range gauge charts.

  1. 1. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your dashboard file containing the data.
  2. 2. Apply normalization formulas: Enter the formula =(Value - 0.5)/(1 - 0.5) in a helper column to scale your data between 50% and 100%.
  3. 3. Create your Doughnut Chart: Go to the 'Insert' tab, select the Doughnut chart, and use your normalized data to form the gauge background.
  4. 4. Overlay the Pie Chart pointer: Add a second data series as a Pie Chart, right-click to format it, adjust the 'Angle of first slice' to 270 degrees, and set the non-pointer slices to 'No Fill'.
Fully compatible with Microsoft Excel formulas and chart formatting.Advanced formatting options for Doughnut and Pie charts to build precise gauges.Lightweight software with a familiar, easy-to-navigate interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Excel have a built-in Gauge Chart?

Excel focuses on standard statistical charts like Bar, Line, and Pie charts. Gauge charts are considered custom visualizations and are typically constructed by combining a Doughnut chart (for the dial) and a Pie chart (for the needle).

Can I change the gauge chart range to numbers instead of percentages?

Yes. The normalization formula =(Value - Min) / (Max - Min) works for any numerical range, such as 200 to 500. Just replace the percentage values in your formula with your target numeric minimums and maximums.

How do I rotate the gauge chart so the half-circle is at the top?

Right-click the chart series and select 'Format Data Series'. Change the 'Angle of first slice' to 270 degrees. This will rotate the Doughnut or Pie chart so the visual gauge rests on a horizontal axis.

Will my custom gauge chart formulas work if I open the file in WPS Office?

Absolutely. WPS Spreadsheet fully supports Excel's mathematical formulas and chart overlay techniques, meaning your custom gauge charts will display and function perfectly without losing any formatting.