View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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.