Plotting Point on Gridline
 

I have a graph that I made but I'm having an issue with the points being
plotted on it. It's a custom type chart (lines on 2 axes). I have
everything on there and it is all working, but my points are being shown in
between my x axis values instead of on the gridline. ie: if the data is
associated with 80,000 sq ft it shows the point in the space between 80,000
and 90,000 sq ft rather than on the gridline for 80,000 sq ft. Is there any
way to change this so that the point will appear on the 80,000 sq ft
gridline? I'm not sure that I described this well, but I tried. I would
appreciate any help that you can offer.

Plotting Point on Gridline
 

Hi,

Try, double clicking the category axis and on the scale tab uncheck the
Y (value axis) crosses between categories.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"lblunier" wrote in message
...
I have a graph that I made but I'm having an issue with the points being
plotted on it. It's a custom type chart (lines on 2 axes). I have
everything on there and it is all working, but my points are being shown
in
between my x axis values instead of on the gridline. ie: if the data is
associated with 80,000 sq ft it shows the point in the space between
80,000
and 90,000 sq ft rather than on the gridline for 80,000 sq ft. Is there
any
way to change this so that the point will appear on the 80,000 sq ft
gridline? I'm not sure that I described this well, but I tried. I would
appreciate any help that you can offer.