How to Set an Excel Chart Y-Axis Maximum to 100 Percent
Question details
The user needs to manually set the maximum value of a chart's vertical (Y-axis) to exactly 100%.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Customizing a chart's visual scale to properly reflect percentage-based data.
- Observed behavior
- The chart's vertical axis does not automatically reach 100% because the plotted data points do not reach that value, leaving a misleading visual scale.
Ensure your chart is already generated and check whether the source data plotted on the Y-axis is formatted as actual decimal percentages or whole numbers.
Manually Adjust the Axis Bounds
Use the Format Axis pane to change the maximum bound of the vertical axis to represent 100%.
When working with percentage data in spreadsheets, the necessary maximum bound depends entirely on how the underlying data is stored. If your data is in a true decimal percentage format (where 100% equals 1.0), you must set the maximum bound to 1. If it is stored as standard whole numbers, set the bound to 100.
Click anywhere on your existing chart to select it, then double-click the Y-axis (Vertical Value Axis) to open the Format Axis pane on the right side of your screen.
In the Format Axis pane, click on the Axis Options icon, which is typically represented by a small bar chart symbol.
Under the Bounds section, locate the 'Maximum' field. Type '1' if your source data uses decimal percentages, or type '100' if it is stored as whole numbers.
Press Enter to apply the changes. The chart's Y-axis will immediately adjust to end at exactly 100%.
Create and Customize Charts in WPS Spreadsheet
WPS Spreadsheet provides powerful and intuitive chart formatting tools. You can easily adjust axis bounds, modify data formats, and create professional visualizations just as you would in Microsoft Excel.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet file containing the chart you wish to edit.
- 2. Access Axis Properties: Double-click the vertical axis of your chart to prompt the Format Axis task window on the right side of the interface.
- 3. Adjust the Maximum Bound: Navigate to Axis > Axis Options. Under the Bounds setting, enter 1 (for decimal percentages) or 100 into the Maximum box.
Frequently Asked Questions
Why does my chart's Y-axis show 1 instead of 100%?
This happens because spreadsheet software stores percentages as decimals (e.g., 100% is stored as 1.0). To fix this visual display, expand the 'Number' section in the Format Axis pane and change the Category format to 'Percentage'.
How do I change the intervals between numbers on the Y-axis?
In the Format Axis pane under Axis Options, locate the 'Units' section. Change the 'Major' value to your desired interval step (for example, enter 0.1 if you want the axis to step by 10% increments).
Will the Y-axis maximum change if I update my chart data?
No. Once you manually type a value into the Maximum box under Axis Bounds, you override the software's 'Auto' setting. The axis maximum will remain permanently fixed at your specified value even if the underlying chart data is updated.
