'%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 Create an Excel Chart with Multiple Markers on One Axis
Question details
The user needs to construct a score or spectrum chart in Excel where several data-point markers are aligned along the same horizontal axis and row.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a custom visual tracking or project chart (such as a spectrum or slider chart) that plots multiple distinct values on a single baseline.
- Observed behavior
- The goal is to correctly scale the axis and use separate plotted XY scatter series to ensure all markers align perfectly on the same row without overlapping or axis distortion.
Ensure your data is organized into clear columns, with specific X-values (marker positions or percentages) and a consistent Y-value (baseline row position) for every data point you want to plot.
Use XY Scatter Series with a Fixed Horizontal Axis
Plot multiple markers on a single row by combining a baseline series with additional XY Scatter series, keeping the Y-axis value constant.
To place multiple markers on the same axis without disrupting the chart's layout, you must use an XY Scatter chart. By assigning the exact same Y-value to different X-value data points, you force all markers to sit on the same horizontal plane.
Select your baseline data and insert a standard Scatter chart from the Insert tab.
Right-click the chart, choose 'Select Data', and click 'Add' to create a new series for your first marker. Set its X-value to the desired percentage or score, and its Y-value to a fixed number (e.g., 1) to keep it on the baseline row.
Repeat the 'Add Series' step for any additional markers, ensuring they all share the exact same Y-value (e.g., 1) so they align horizontally.
Right-click the horizontal axis, select 'Format Axis', and set the Bounds to a consistent range. For example, set Minimum to 0.0 and Maximum to 1.0 (or 100) so the chart does not auto-resize when new markers are added.
Right-click each data point to add data labels, and use the Format Data Series pane to customize the marker shapes, colors, and sizes to differentiate them.
Create Advanced Charts Easily with WPS Spreadsheet
WPS Spreadsheet provides powerful charting tools, allowing you to create custom spectrums, multiple-marker charts, and complex XY scatter plots with ease. It is fully compatible with Microsoft Excel files.
- 1. Prepare your dataset: Open your dataset in WPS Spreadsheet, ensuring you have designated X-values for marker placement and identical Y-values for row alignment.
- 2. Insert Scatter Chart: Go to the 'Insert' tab, click the 'Chart' icon, and select an 'XY Scatter' chart type.
- 3. Add data series: Right-click the chart area, click 'Select Data', and add your individual marker series with matching Y-values to force them onto the same row.
- 4. Format the axis: Double-click the horizontal axis to open the right-side formatting pane and set fixed Minimum and Maximum bounds to lock the scale.
- 5. Customize appearance: Use the 'Chart Elements' tool to customize marker styles, add distinct colors, and display individual data labels.
Frequently Asked Questions
Why are my markers appearing on different rows instead of a single axis?
This happens if your Y-values for the marker series are not identical. In an XY Scatter chart, the Y-value determines the vertical height. Ensure all markers you want on the same row share the exact same Y-axis value in your dataset.
How do I label each marker individually on the same axis?
Right-click a specific marker and select 'Add Data Labels'. Then, format the data label to show the Series Name or a custom value from a cell, rather than the default X or Y coordinate.
Can I create this multiple-marker chart using a standard line chart?
While possible, it is highly recommended to use an XY Scatter chart. Scatter charts allow precise control over both the horizontal (X) and vertical (Y) placement of individual points, making it much easier to plot independent values on a single continuous axis.
How do I prevent data markers from overlapping if their values are too close?
If values overlap on the axis, you can manually drag the data labels so they are readable. To separate the actual visual markers slightly, you can slightly adjust the Y-values (e.g., 1.05 and 0.95 instead of exactly 1.0) to create a staggered visual effect.
