Simple X Y Graph ... I thought

[Guest]

I'd like to make a simple XY graph. I want a 5 x 5 grid with two points
plotted.

My problem is, I want the points to fall between the grid lines, not on them.

In other words, for a point of X=1, Y=1; I want the dot to be in the middle
of the bottom, left square.

Of course, I'd want the axis marks to be within the gridlines also (i.e.,
the X-axis label of "1" would be written in between the Y-axis and the first
gridline).

Is there a way to do this?

Thanks!

-Debbie

 

[Bernard Liengme]

Have you thought of using a Line chart or adding 0.5 to the data to be
plotted?

 

[Jon Peltier]

Debbie -

You could make some fake gridlines, following this procedure:

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

If the squares are to be centered on the whole numbers, the min and max of each axis
need to be at 0.5 and 5.5, so you probably need custom axis labels, to only get the
whole number labels:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______