Data points going from axis to axis
 

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.

--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000

Data points going from axis to axis
 

Hi,

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

Cheers
Andy

Ronald Dodge wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

Data points going from axis to axis
 

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.

--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000

"Andy Pope" wrote in message
...
Hi,

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

Cheers
Andy

Ronald Dodge wrote:
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, Microsoft MVP - Excel
http://www.andypope.info