'%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 Set Custom Excel Chart Gridline Spacing to 100
Question details
The user wants to configure an elevation-profile chart so that the distance labels and gridlines appear exactly at 100-meter intervals.
- Product
- Excel / Spreadsheets
- Device & OS
- not provided
- Scenario
- Creating an elevation-profile chart with custom distance intervals to properly visualize spatial data.
- Observed behavior
- The chart currently displays hundreds of automatically generated gridlines instead of the targeted 100-meter interval spacing.
Ensure your data uses continuous numeric values and that you have selected an XY (Scatter) chart, as standard Line charts treat the horizontal axis as discrete text categories.
Adjust Axis Options to Set Major Unit Spacing
Modify the axis major unit to explicitly define the numerical interval between gridlines and data labels.
In Excel, gridline spacing is directly tied to the axis units. By modifying the Major unit in the Format Axis pane, you force the chart to draw gridlines and labels exactly at your specified interval.
Click directly on the horizontal or vertical value axis in your chart that requires the 100-unit spacing.
Right-click the selected axis and choose 'Format Axis' from the context menu to open the formatting pane on the right side of your screen.
In the Axis Options section, input your desired Minimum and Maximum bounds for the chart based on your elevation data.
Locate the 'Units' section under Axis Options and set the 'Major' value to 100. Press Enter to apply the changes to your gridlines.
Set Custom Gridline Spacing in WPS Spreadsheet
Easily adjust axis options, format gridlines, and customize data visualizations in WPS Spreadsheet. It offers a familiar interface for managing your data while remaining completely free.
- 1. Insert a Scatter Chart: Select your distance and elevation data, go to the Insert tab, and choose an XY (Scatter) chart.
- 2. Access Axis Properties: Double-click the axis you want to modify in order to quickly open the Axis properties dialog.
- 3. Set Major Unit: Navigate to the Axis Options section, change the Major unit spacing to 100, and close the panel to apply.
Frequently Asked Questions
Why can't I change the major unit on my horizontal chart axis?
If you are using a standard Line chart, the horizontal axis is treated as text categories, not numeric values. You need to change your chart type to an XY (Scatter) chart to enable numeric scaling and major unit adjustments on the X-axis.
How do I change the color and thickness of the 100-meter gridlines?
Once your spacing is set to 100 via the Axis Options, click directly on the gridlines in the chart. Right-click and select 'Format Gridlines' to change their color, dash type, and line thickness.
Will changing the major unit to 100 alter the position of my data points?
No, changing the major unit only affects the visual gridlines and the frequency of the axis labels. Your actual data points will remain plotted accurately based on their underlying values.
