OmniDocHow to adjust the scale of the coordinate axis of the PPT chart and how to change the value of the vertical axis
Explain how to manually set the lower limit, upper limit and scale interval of the vertical axis of the PPT chart, explain what issues should be confirmed before changing the scale, and provide a verification method after the change is made to avoid misreading the chart.
Key points of this article
- The vertical axis scale is mainly determined by the lower limit, upper limit and major scale unit. Adjusting one of them will usually make the chart reading clearer.
- Only native charts can change the coordinate axes directly. Charts in picture form must be returned to the data source and regenerated.
- It is recommended that the lower limit of the vertical axis of the histogram be kept at 0. After truncation, the gap between the columns will be enlarged, which can easily mislead readers.
- Adjusting a single vertical axis and adding a second vertical axis are two different settings, do not mix them.
- After changing the scale, check whether the data labels, units and columns or polylines are truncated.
If you have put a line chart or bar chart in your PPT, you have probably encountered this situation: the vertical axis goes from 0 to 1200, and the data points are crowded in the lower half of the chart, making the fluctuations difficult to see; or the scale automatically changes to decimals such as 0, 0.5, 1, and 1.5, which does not match the integers that readers are accustomed to. What needs to be adjusted at this time is the scale setting of the vertical axis. Usually there is no need to redraw the entire picture.
This article is written for people who need to make data charts in presentations, such as colleagues who want to use a 12-month sales data chart, or students who want to put experimental results into their defense PPT. After reading, you will be able to distinguish the three key settings of the vertical axis, know how to manually modify it in PPT, and also know how to check whether the chart is still true and readable after modification.
How to adjust the vertical axis scale? One sentence conclusion
The vertical axis scale is mainly controlled by three values: lower limit, upper limit and major scale unit. In most cases, setting the lower and upper limits to integers that are close to the data range, and then setting the scale intervals to steps that are easy for readers to read, will make the chart clearer. Bar charts should retain a lower limit starting from 0 to ensure that bar heights can be directly compared.
| your situation | Recommended practices | reason |
|---|---|---|
| Line chart with data concentrated in the upper range (such as 1000 to 1200) | Set the lower limit to an integer slightly lower than the small value of the data, such as 950 | Line charts express changing trends, and narrowing the range can highlight fluctuations. |
| Bar chart, compare the size of each item | The lower limit remains at 0, and only the upper limit and scale interval are adjusted. | The height of the column represents the numerical value. Truncation of the vertical axis will magnify the gap. |
| The scale is shown as 0.5, 1.5 but the raw data is integers | Set the major scale unit to an integer, such as 100 or 200 | The scale step size is consistent with the reader's habits, and the reading is more direct |
| The data exceeds the upper limit of the scale and the top of the column is cut off | Manually set the upper limit to an integer slightly higher than the maximum value of the data | The automatic range sometimes does not fully include extreme values, and a margin needs to be left manually |
| Need to scale another set of data with different dimensions | This is a dual vertical axis setup and is not within the scope of single axis adjustment in this article. | The two sets of numerical values in the biaxial chart have different meanings and need to be explained separately. |
Before you start: Confirm these points first
- Confirm that the chart is a native chart. After clicking on the chart, if you can select the columns, lines and coordinate axes and see the corresponding data table, you can directly modify the coordinate axes. If it can only be moved as a whole, it is probably a picture. To change the scale, you can only go back to the original table or draw tool to regenerate it.
- View the actual range of data. First find the small and large values in the data, and then determine the lower and upper limits. If the range is set too tightly, new data will easily exceed it; if the range is set too loosely, the data will be squeezed in the middle.
- Confirm the chart type. Column charts and area charts rely on length or area to read, and truncating the vertical axis will mislead readers; line charts pay more attention to changing trends and can narrow the range appropriately. The chart type determines whether you can change the lower limit.
- Keep original data. Modifying the scale only changes the display mode, not the data itself. If the chart is copied from a table, try to keep the original table for easy verification later.
- Unified unit. If the value is in tens of thousands of yuan, percentages or thousands of people, the scale and title must indicate the same unit, otherwise readers are prone to conversion errors.
Steps to manually modify the vertical axis scale in PPT charts
- Select the chart. Click the chart area and confirm that an editing border appears around the chart, indicating that you have entered the chart editing state.
- Select the vertical axis. Click on the numerical scale area on the left side of the chart. If the entire chart or the horizontal axis is selected, click once more on the numerical portion of the vertical axis.
- Open the axis format settings. Right-click after selecting the vertical axis and select options related to setting the axis format. The software usually displays the settings panel on the right or in a pop-up window. The location may vary slightly between versions, but the option names are generally similar.
- Set lower and upper limits. Find the boundary item in the axis options and change the lower limit and upper limit to manually entered numbers. The lower limit of the column chart is filled with 0, and the line chart can be filled with an integer slightly lower than the small value of the data.
- Set the major scale unit. Find the unit or scale interval in the same panel and fill in a step size that is easy for readers to read, such as 200 or 0.5. If the step size is too small, the scale will be too dense, and if the step size is too large, the reading will not be accurate enough.
- Adjust number format (if necessary). If the scale wants to display thousandths or percent signs, select the corresponding category in the number format and set the number of decimal places to be consistent with the data.
- Close the panel and check the screen. Observe whether the vertical axis scale is fully displayed and whether the top of the column or polyline is cut off.
- Check data labels. If there are data labels on the chart, make sure they match the values in the data sheet.
📊 Core comparison: How to choose between automatic scale and manual scale
| Way | Suitable situation | Things to note |
|---|---|---|
| Automatic scale | Charts need to be generated quickly after data changes, and there are no special requirements for scale. | The lower limit may not be zero, and the scale steps may be irregular, requiring manual verification |
| Manually set lower and upper limits | You need to highlight variations or unify the vertical axis range across multiple maps | After the data update, the scope may no longer be suitable and needs to be re-examined |
| Manually set the scale intervals | Readers need to read quickly, hoping the scale matches daily habits | When the step length is too large, subtle differences are not noticeable |
After completion, check each item one by one
| Inspection items | How to see it | What should you do if there's a problem? |
|---|---|---|
| Longitudinal axis range | Check whether the high scale is higher than the big data point, and whether the low scale matches the chart type | If the upper limit is too low, raise it; If the lower limit of the bar chart is not 0, change it back to 0 |
| Scale step length | Check whether the scale is uniform and whether readings can easily correspond to data points | If the scale is too dense, increase the unit; if too sparse, decrease the unit |
| Whether the column or line is cut off | Check whether the high-contrast data points reach the edge of the chart | Increase the upper limit and leave some margin |
| Data labels | Check whether the label numbers match the datasheet | If inconsistent, return to the data table to correct it; do not directly change tags to cover up differences |
| Units and titles | Whether the chart title or axis title indicates the unit | Supplementary units, such as "ten thousand yuan" or "%" |
| Open on other devices | Check if the font and layout are off | Check if the font is usable, and if necessary, switch to a universal font |
The accuracy of the data must also be verified. If the chart values are manually compiled or machine-translated, please verify the original data item by item before publishing; do not just look at whether the chart looks good.
❓ Frequently Asked Questions (FAQ)
1. What is the difference between adjusting a single vertical axis and adding a second vertical axis?
Adjust a single vertical axis to modify only the lower limit, upper limit, and scale interval of one axis; all data shares the same set of scales. The second vertical axis is used to assign scales to another set of data with different dimensions; the reading of these two sets of values needs to be explained in the legend or heading.
2. The lower limit was changed, but the chart did not change. Why?
A common reason is that instead of the vertical axis, the horizontal axis or the entire chart is selected. Please click the number area on the vertical axis again and try again. If there is still no change, it means the chart may be an image and needs to be regenerated from the original data.
3. Why does the vertical axis scale always display decimals?
They are usually results automatically generated in numeric format or scale units. Set the main scale unit to an integer and set the decimal place in the numeric format to 0, and the scale will become an integer.
4. If the chart is copied from another file, can the vertical axis be changed?
If the copied chart is still a native editable chart, you can modify it according to the steps above. If only images remain, you need to request the original table from the data provider and recreate the chart.
📝 Summary
To adjust the coordinate axis scale in a PPT chart, the key is to first confirm that the chart is native and determine the chart type, then set the lower bound of the vertical axis
