'%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 Fix Duplicate Numbers on an Excel Chart Axis
Question details
The user needs to resolve an issue where an Excel chart displays duplicate numbers on the vertical axis instead of a proper numeric scale.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Editing or creating a chart in Excel where the vertical axis scale requires adjustment.
- Observed behavior
- The vertical axis labels show duplicate numbers, such as 1, 1, 2, 2, instead of a continuous and accurate numeric sequence.
Ensure you have selected the specific chart and clicked directly on the vertical axis that is displaying the incorrect duplicate numbers before adjusting the settings.
Change Axis Format to General and Unlink from Source
This is the most effective solution when hidden formatting or incorrect source links cause the axis numbers to duplicate.
Often, the chart inherits conflicting formatting from the source data. Changing the category to General and breaking the link to the source data forces Excel to recalculate the axis labels correctly.
Click directly on the vertical axis of your chart so that a bounding box appears around the numbers.
Right-click the selected axis and choose 'Format Axis' from the context menu to open the formatting pane on the right.
Scroll to the bottom of the Format Axis pane and expand the 'Number' section.
Click the 'Category' dropdown and select 'General'. Ensure that the 'Linked to Source' checkbox is deselected.
Increase Decimal Places in Number Format
Use this method if your data contains decimal values but the axis is formatted to show zero decimal places.
Use Paste Values to Clear Hidden Formatting
If adjusting the axis settings directly fails, copying the data and pasting it as values removes stubborn hidden formatting.
Effortlessly Format Charts with WPS Spreadsheet
WPS Spreadsheet provides an intuitive interface for creating professional charts. You can easily adjust axis scales, format numbers, and customize visualizations without dealing with complex hidden formatting issues.
- 1. Open your data: Launch WPS Spreadsheet and open your existing workbook containing the data.
- 2. Insert a chart: Highlight your data, navigate to the 'Insert' tab, and select your preferred chart style.
- 3. Format the axis easily: Double-click the vertical axis to instantly open the properties pane, where you can quickly set the Number format to General.
Frequently Asked Questions
Why is my Excel chart axis showing repeating numbers?
This usually occurs when the axis values include decimals (such as 1.2 and 1.4), but the axis format is set to display zero decimal places. Excel rounds these values to the nearest whole number, making them appear as duplicates (e.g., both rounding to 1).
How do I change the major unit on a chart axis?
Right-click the axis and select 'Format Axis'. Under the 'Axis Options' tab, locate the 'Units' section and adjust the 'Major' value to define the specific intervals between the numbers displayed on the axis.
What does 'Linked to Source' mean in axis formatting?
When 'Linked to Source' is checked, the chart axis automatically adopts the specific number formatting of the cells it pulls data from. Deselecting this option allows you to format the chart axis independently from the source data.
