Data points going from axis to axis

[Ronald Dodge]

Without necessarily deleting the chart and then recreate a whole new chart,
how can I get the data points to revert back to being in the center of all
columns rather than equally spaced starting from the left axis to the right
axis?

This issue was brought about by way of using the Area method for one of the
data series, but went attempting to revert back, it doesn't go back to the
original line data format as described above? It goes back to the line, but
the data points are not at the same places.

 

[Andy Pope]

Hi,

Try double clicking the x axis and on the scale tab check
'Value (Y) axis crosses between categories'

Cheers
Andy

 

[Ronald Dodge]

Thank you for your help as I didn't even think of looking within the X axis
Format as I normally have that not shown anyhow. Given how the X-axis tends
to work, I just use the worksheet instead.