'%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 the Horizontal Data Range in an Excel Chart
Question details
The user needs to adjust the horizontal (X-axis) data range for an Excel chart, which varies depending on the chart type.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Customizing the chart's data source to correctly display horizontal category labels or X-axis values.
- Observed behavior
- The current horizontal axis data needs updating, requiring different steps for category-based charts versus value-based scatter charts.
Identify the type of chart you are working with (e.g., Column, Bar, Line, or XY Scatter), as the steps for editing category labels versus numeric X-values differ slightly.
Change Horizontal Axis Labels for Column, Bar, and Line Charts
Use the Select Data Source dialog box to quickly update category labels for standard charts.
Column, bar, and line charts use text-based category labels for their horizontal axis. Modifying this range will update the names appearing under each data point or bar.
Click anywhere on your chart to highlight it and reveal the Chart Design tab on the ribbon.
Navigate to the 'Chart Design' tab and click on the 'Select Data' button.
In the 'Select Data Source' dialog box, look at the right pane titled 'Horizontal (Category) Axis Labels' and click the 'Edit' button.
Highlight the new range of cells in your worksheet that contain the updated labels, then click 'OK' twice to apply the changes.
Modify X-Values for XY Scatter Charts
Scatter charts use numeric values for the horizontal axis instead of text labels, so you must edit the specific data series.
Easily Manage Chart Data with WPS Spreadsheet
WPS Office provides an intuitive and free alternative for creating and editing charts. You can seamlessly adjust data ranges, format axes, and customize chart elements with complete Microsoft Excel compatibility.
- 1. Open your workbook: Launch WPS Spreadsheet and open your existing Excel workbook.
- 2. Select the chart: Click on the chart to activate the 'Chart Tools' contextual menu.
- 3. Access data settings: Click the 'Select Data' icon located on the top ribbon.
- 4. Edit horizontal range: Edit the 'Category (X) axis labels' or 'Series X values' depending on your chart type by highlighting the new data range.
- 5. Apply changes: Click 'OK' to instantly apply the updated horizontal data range to your chart.
Frequently Asked Questions
Why is the 'Edit' button under Horizontal Axis Labels grayed out?
If the 'Edit' button is grayed out, you are likely working with an XY Scatter or Bubble chart. For these chart types, the horizontal axis relies on the 'Series X values', which must be modified by editing the series directly on the left side of the Select Data dialog.
Can I type the horizontal data range manually instead of selecting cells?
Yes, in the Axis Labels or Series X values box, you can manually type the absolute range reference (e.g., =Sheet1!$A$2:$A$10) or enter a comma-separated array of values enclosed in curly brackets.
How do I fix blank spaces on my chart's horizontal axis?
Blank spaces usually occur if your selected horizontal data range includes empty cells. Go to 'Select Data', edit the horizontal axis labels, and ensure the newly selected range exactly matches your populated data rows.
What is the difference between category labels and X-values?
Category labels (used in column, bar, and line charts) treat the horizontal axis as text groupings, placing data points evenly spaced apart. X-values (used in scatter charts) plot data according to numeric scales, reflecting precise mathematical positions.
