Secondary axis not aligning to X axis

K

Katie

Hi,

Our secondary series (scatter graph) is not aligning to the X axis values
with the primary series (bar graph).

The secondary series is aligning with the gridlines not the X axis values.
The Primary is aligning with the X axis values as required.

How do we make the Secondary series align with the X axis values like the
Primary series is?
 
B

Bernard Liengme

If you open the Format Axis dialog for the column chart you will see a
setting: Position Axis On tick marks OR Between tick marks
For more detailed answers please tell us what version of Excel (2003- or
2007+)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
Make Y-axis values correspond to x- axis value 1
Gantt chart duration not showing 0
Primary X axis to Secondary X axis 1
Use text descriptors as Y axis units 1
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Overlaying 2 Data Series with Different Time (X) Axis 3
Chart distorts secondary axis when the x-axis is logarithmic 5

Top