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

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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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