OmniDocHow to set the intersection point of x-axis and y-axis in Excel chart? How to adjust the horizontal coordinate position
Explain clearly how to adjust the intersection point of the horizontal and vertical axes and the position of the abscissa in an Excel chart, distinguish three things such as axis intersection, scale range and label position, and provide operation steps, selection judgment and result verification methods.
Key points of this article
- The coordinate axis intersection point refers to where one axis "crosses" the other axis. It is three different settings from the scale range and label position.
- When the data has negative values, the abscissa stops at the zero line by default, and the column and label will overlap. A common practice is to set the label position to "low" instead of hard moving the axis.
- If you want the vertical axis to appear at a certain category, use "vertical axis crosses the category"; if you want the horizontal axis to stop at a certain value, use "specify axis value".
- After adjustment, check the axis position, column starting point and label readability, and confirm that the data has not been misread due to changing the cross position.
When making Excel charts, many people find that the abscissa (x-axis) does not stay at the bottom of the chart, but stops at a line in the middle; the column grows downward from the zero line, and the text is pressed on the column; or they want the ordinate (y-axis) to appear somewhere other than the left, but cannot find the entrance. The root cause of this type of problem is usually that the "coordinate axis intersection points" are not set correctly.
This article is written for people who need to organize reports, paper charts or reporting materials. After reading, you will be able to distinguish three things: coordinate axis intersection, scale range and label position, know which one to change, and follow the steps to adjust the abscissa position to the desired place. The operations in this article are based on the common desktop version of Excel. The interface name may be slightly different depending on the version, but the idea is universal.
How to adjust the abscissa position? Which method should be used in which case? One sentence conclusion
Direct answer: The horizontal coordinate position is determined by "which value on the vertical axis the horizontal axis crosses at", and the vertical coordinate position is determined by "which category on the horizontal axis the vertical axis crosses at". Adjusting the cross position changes the axis itself; if you just want the text to move away from the column, you should change the label position.
| your situation | Recommended practices | reason |
|---|---|---|
| The data is either positive or negative, and I want the horizontal axis to stop at the bottom | Set the abscissa label position to "low" | The axis remains at the zero line, the labels are moved to the bottom of the chart, and the bars are not affected |
| You want the horizontal axis to stop at a specific value, such as 20 | Set "the horizontal axis crosses the specified coordinate axis value" in the vertical axis format | Directly control the value that the axis passes through |
| Do you want the vertical axis to appear after or before a certain category? | Set "vertical axis crosses category" in the abscissa axis format | Position the vertical axis according to the category number, suitable for charts with many categories |
| I just want to change the starting and ending range of the scale | Adjust the minimum and maximum values of the coordinate axis | This is the scale range and does not affect the intersection position |
| Want to swap horizontal and vertical directions | Change chart type or rearrange data | Exchange is not an intersection setting, it requires changing the data organization method. |
Before you start: Confirm these points first
First see clearly which problem you want to solve. There are three common settings for the "axis" in charts: the intersection position determines where the axis passes through, the scale range determines the value from high to high, and the label position determines which side the text is placed on. The three are often mixed together. If you only adjust the scale range, the axis position will not change, but you will be busy in vain.
Confirm whether the data has negative values. When there are only positive numbers, the horizontal axis is at the bottom by default, and generally there is no need to change the cross position. After negative values appear, the horizontal axis will run to the zero line, which is a common source of problems.
Confirm chart type. The coordinate axes of column charts, bar charts, line charts, and scatter charts can all have cross positions set, but both axes of scatter charts are numerical axes, and the setting method is slightly different from the classification axis. If your horizontal axis is date or text classification, just follow the "Category" option in this article.
Back up the original chart or keep a copy. The coordinate axis settings are not very irreversible, but it is easy to forget the original values after repeated modifications, so keep a copy for comparison.
Note the source of the chart. If the chart was copied from a PDF or other file, the data may have been fixed as an image. At this time, you need to find the original table first, or import the content into Excel and re-draw the graph.
Steps to set the horizontal axis position
- Open the Excel file containing the chart and click on the blank space of the chart. In this way, the chart is selected and control points appear around it, and subsequent operations will be applied to this chart.
- Click the coordinate axis you want to adjust. To adjust the horizontal axis, click the horizontal axis at the bottom of the chart to make sure it is selected individually, not the entire chart or a certain data series.
- Open the axis format setting panel. Right-click on the selected axis, select the corresponding option such as formatting the axis, the window or sidebar will open, and then switch to the axis options page.
- Find the option to control the intersection position. In the format settings of the horizontal axis, find the option for setting the intersection position of the vertical axis, change it to a specified value, and then enter a number, such as 0 or 20, and the horizontal axis will move to this value.
- If you want to adjust the vertical axis position, use the cross setting of the abscissa axis instead. Click the vertical axis, find the option of horizontal axis crossing or vertical axis crossing category in the format panel, select set by category number or end category, and the vertical axis will move accordingly.
- If you only want the label to leave the column, change the label position. Keep the cross position unchanged, click on the horizontal axis, and change "Label Position" to "Low" in the label options. The text will now move to the bottom of the chart and the bars will still start from the zero line.
- Adjust the scale range as needed. If the data display is incomplete after adjusting the cross position, check the minimum and maximum values of the axis to ensure that all data points are within the visible range.
- Close the panel to view the overall effect of the chart. Make sure the axes, labels, and data series are positioned as expected before saving the file.
Check each item after completion
Once you've finished adjusting your chart, don't just take a glance and turn it off. The following checklist can help you avoid misreadings.
| Check items | How to see | What should you do if there's a problem? |
|---|---|---|
| Axis position | Check whether the horizontal axis stops at the value you specify, and whether the vertical axis is at the specified classification | Go back to the format panel and confirm that you selected the cross option instead of the scale range |
| Pillar starting point | Check whether the columns in the bar chart still start growing from the correct baseline | If the column start point changes, it means the cross value is set incorrectly; revert to the neutral line or other benchmark |
| Label readability | Check whether classification text and numeric labels overlap with columns or lines | Change the tab position to "Low" or "High," and adjust the chart width if necessary |
| Data integrity | Check whether all data points are within the chart range and are not censored | Check the small and large values to ensure all data is included |
| Numerical analysis | Whether the relationship between high and low levels that readers see matches the original data | If the horizontal axis shifts to a non-zero position, a reference line should be indicated on the chart to avoid misreading |
| Chart usage | Charts are used for presentations, papers, or internal analysis | In papers and official reports, it is recommended to specify the reference values of the coordinate axes in the captions |
If your chart needs to be submitted for review or included in English materials, it's recommended to double-check the text section. Content identified by machine translation or OCR may have errors, and important numbers and proper terms must be manually verified.
📊 Core Comparison
There are three common approaches to adjusting the horizontal axis, each suitable for different scenarios:
- Crossing at Zero Line (default): Suitable for comparing positive and negative data, where the zero line itself serves as a meaningful benchmark, such as profit or growth rate.
- Crossing at a Specified Value: Suitable for scenarios where the horizontal axis needs to be placed at a certain threshold, such as using the passing or target lines as horizontal axes, making positive and negative deviations clear at a glance.
- Set tag position to "low": Suitable for scenarios where you don't want to change the axis and only want to solve text overlap; it's a method with minimal changes and low risk.
The comparison of the three approaches can be summarized in the table below:
| Approach | Applicable scenarios | Changes and risks |
|---|---|---|
| Intersecting at the neutral line | Comparing positive and negative data, the neutral line has real meaning | No changes are needed, but the negative value bar easily overwhelms the category text |
| Crossing over the specified value | Thresholds and target lines should be used as horizontal axis references | After the reference is changed, readers may easily misjudge the value and must be noted in the caption |
| Label position set to "Low" | I just want to solve the overlap between text and columns | Only changing the formatting without changing the data benchmark means low risk |
There is no absolute superiority or inferiority among the three approaches; the key is to look at the message conveyed by the chart. If changing the cross position causes readers to misunderstand the data orientation, it is better to keep the neutral line and then use the label position to solve the layout problem.
❓ Frequently Asked Questions (FAQ)
1. The horizontal axis is in the middle of the chart; can it be dragged directly to the bottom?
You can drag it, but a safer approach is to modify the crossover or label positions. Dragging directly may cause the axis to misalign with the scale, and the position may change when opened on another computer.
2. After adjusting the small value of the coordinate axis, why hasn't the horizontal axis position changed?
Small and large values only determine the scale range, not where the axis passes. To move the horizontal axis, you need to modify the cross settings of the horizontal axis.
3. The chart was copied from the PDF. Can I directly change the coordinate axes?
If the copy is a regular image, it cannot be directly modified. You can first export it as an Excel file using a PDF editor, then recreate the diagram after finding the original data. The PDF editor in the OmniDoc desktop client supports exporting PDFs to Excel, with the download link download.omnidoc.top. After exporting, the table still needs to be checked for numbers and formatting, especially for multi-column alignment.
4. The horizontal axis is on the neutral line, but the label has slipped to the middle of the column. What should I do?
This is a typical sign of label positions not being adjusted. Select the horizontal axis and set the label position to "Low"; the text will move to the bottom of the chart, separated from the bar.
5. Can both the horizontal and vertical axes of a scatter plot be set this way?
Both axes of a scatter plot are numeric axes, and intersection positions can be set separately. The horizontal axis usually crosses at a certain value on the vertical axis, and the vertical axis crosses at a certain value on the horizontal axis. When operating, pay attention to which axis is selected.
📝 Summary
The horizontal axis position of Excel charts is determined by cross settings, vertical axis positions are categorized by vertical axis cross categories, and tab positions and scale ranges are set separately. First, determine which category the problem belongs to, then adjust it step by step. Using the results of checking the axes, column starts, and labels, you can adjust the chart to the desired effect.
