'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Change Excel Y-Axis Number Format and Intervals
Question details
The user needs to change the number formatting on a chart's Y-axis and manually adjust the spacing interval between the axis labels.
- Product
- Spreadsheets
- Device & OS
- not provided
- Scenario
- Customizing chart aesthetics to make data clearer by adjusting Y-axis number displays and scale units.
- Observed behavior
- Numbers are displaying in scientific notation (e.g., 2.00E-05) or with inappropriate spacing, and need to be formatted to standard decimals (e.g., 0.00002) with custom label intervals.
Ensure your chart is already generated with the correct data source, as modifying axis formats is most effective when the underlying data is finalized.
Format Axis Number Category and Major Units
Use the Format Axis pane to change the number display format from scientific to custom decimals and manually set the major unit intervals for the Y-axis.
By accessing the Format Axis menu, you can override Excel's automatic scaling and number formatting. This allows you to display very small or very large numbers accurately without scientific notation.
Select the chart Y-axis by clicking on the numbers. Right-click the selected axis and choose 'Format Axis' from the context menu.
In the Format Axis pane, scroll down and expand the 'Number' section. Click the Category dropdown and select 'Number' or 'Custom'.
Set the required decimal places or enter a specific format code, such as 0.00000, to force numbers like 2.00E-05 to display as 0.00002.
To change the spacing between labels, navigate to the 'Axis Options' section in the same pane.
Locate the 'Major' unit field and input your preferred interval value, such as 0.00001. The axis will immediately update to display intervals evenly spaced at your specified value.
Format Chart Axes Easily with WPS Spreadsheet
WPS Spreadsheet provides an intuitive interface for customizing charts, including precise control over axis formats, intervals, and labels. It perfectly supports all your existing Microsoft Excel chart elements.
- 1. Open File in WPS Office: Launch WPS Spreadsheet and open the document containing your chart.
- 2. Access Axis Options: Double-click the Y-axis of your chart to instantly open the Format Axis dialogue box on the right side of the screen.
- 3. Modify Units: Under Axis Options, change the Major and Minor unit bounds to set your desired label intervals.
- 4. Update Number Formatting: Navigate to the Number tab within the menu, select Custom or Number, and apply your preferred decimal format.
Frequently Asked Questions
Why does my Excel Y-axis show numbers with an 'E' like 1E+06?
This is scientific notation, automatically applied when numbers are very large or very small. You can fix this by changing the axis number format to 'Number' or a 'Custom' format in the Format Axis pane.
Can I set a maximum and minimum limit for the Y-axis?
Yes. In the Format Axis pane under Axis Options, locate the Bounds section. You can manually type your desired Minimum and Maximum values instead of leaving them on 'Auto'.
How do I add a currency symbol to my Y-axis labels?
Right-click the Y-axis, select Format Axis, expand the Number section at the bottom, and choose 'Currency' or 'Accounting' from the Category dropdown menu.
Why are my Y-axis intervals overlapping or too crowded?
This happens when the major unit interval is too small for the physical size of the chart. Increase the Major unit value in the Axis Options to space out the labels, or make the chart taller.
