How to Change the Value Range of an Excel Gauge Chart
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.

- 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%.
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.
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.
In a blank section of your sheet, enter your new scale limits. For example, set 50% as your Minimum and 100% as your Maximum.
Subtract the Minimum from the Maximum (100% - 50% = 50%). This represents the total visual span of your new gauge background.
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%).
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.
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. Open your workbook in WPS Spreadsheet: Launch WPS Office and open your dashboard file containing the data.
- 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. Create your Doughnut Chart: Go to the 'Insert' tab, select the Doughnut chart, and use your normalized data to form the gauge background.
- 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'.

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.




