Simple X Y Graph ... I thought

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

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

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"DebbieMac" wrote in message
...
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

Debbie -

You could make some fake gridlines, following this procedu

http://peltiertech.com/Excel/Charts/...Gridlines.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/
_______

DebbieMac wrote:

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