Data points going from axis to axis

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ronald Dodge - 07 Sep 2006 16:07 GMT

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.

Signature

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

Reply to this Message

Andy Pope - 07 Sep 2006 16:30 GMT

Hi,

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

Cheers
Andy

> 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
[quoted text clipped - 5 lines]
> original line data format as described above? It goes back to the line, but
> the data points are not at the same places.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Ronald Dodge - 07 Sep 2006 17:04 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 13 lines]
> > original line data format as described above? It goes back to the line, but
> > the data points are not at the same places.

Reply to this Message