'%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 Align Excel Combo Chart Bars Between Axis Tick Marks
Question details
The user is unable to align combo chart bars between axis intervals, even after selecting the 'Between tick marks' axis setting.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Customizing the axis position and layout formatting of a combination chart containing multiple data series.
- Observed behavior
- The bars do not align properly between the axis tick marks because incompatible chart types, such as scatter charts, are being used in the combo chart.
Ensure your combo chart does not rely on an XY (Scatter) chart type for any of the data series, as scatter charts use a continuous value axis rather than a discrete category axis and cannot be positioned between tick marks.
Change Incompatible Chart Types in the Combo Chart
Replace scatter charts with category-based charts (like Line or Column) to enable proper category-axis positioning between tick marks.
Excel combo charts often break axis alignment when combining category-based charts (like Bar or Column) with value-based charts (like XY Scatter). Scatter charts plot data on continuous numerical axes, which overrides the 'Between tick marks' setting for the horizontal axis.
Right-click anywhere on the problematic combo chart and select 'Change Chart Type' from the context menu.
In the Change Chart Type dialog box, navigate to the 'Combo' section at the bottom of the left sidebar. Look at the chart type assigned to each data series.
If any data series is set to 'Scatter', click the dropdown menu next to it and change it to 'Line' or 'Clustered Column'.
Click 'OK' to save your changes. The chart should now respect the standard category axis alignment.
Verify Axis Position Settings
Ensure the horizontal axis properties are explicitly set to position data between the tick marks after fixing the chart types.
Create and Align Combo Charts Effortlessly in WPS Office
WPS Spreadsheet provides an intuitive and robust charting interface. You can easily build complex combination charts, format axis intervals, and precisely align your data bars without dealing with frustrating axis compatibility issues.
- 1. Insert a Combo Chart: Open your dataset in WPS Spreadsheet, highlight your data range, navigate to the 'Insert' tab, and click the 'Chart' icon to select 'Combo'.
- 2. Adjust Series Types: In the chart insertion window, ensure your series are set to Line or Column rather than Scatter to maintain category axis formatting.
- 3. Open Axis Properties: Once the chart is created, double-click the horizontal axis to open the Format Object pane on the right side of your workspace.
- 4. Align Between Tick Marks: Navigate to Axis Options and check the 'Between tick marks' option under Axis Position to perfectly align your bars.
Frequently Asked Questions
Why won't my Excel chart bars align between tick marks?
This typically occurs when you mix category-based charts (like Column or Bar) with value-based charts (like Scatter) in a combination chart. Scatter charts rely on a continuous numerical axis and do not support the 'Between tick marks' spacing.
How do I change the chart type for a single series in a combo chart?
Right-click the specific data series (e.g., the line or set of bars) directly in the chart, select 'Change Series Chart Type', and choose your desired chart format from the dropdown menu for that specific series.
What is the difference between 'On tick marks' and 'Between tick marks'?
'On tick marks' centers the data points or column bars directly over the axis intervals. 'Between tick marks' shifts the data so that it sits comfortably in the empty space between two consecutive axis lines.
Can I use a scatter chart and still align it like a column chart?
No. Scatter charts plot points precisely according to X and Y values on continuous axes. They cannot be forced into the discrete, equidistant category layout required to push bars strictly between tick marks.
