Data point on line is not over the point/tick in X axis...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TomCat - 06 Sep 2007 12:10 GMT

I have a simple x-y graph that has manhours on the y axis and months on the x
axis. My first data point sits directly over the corresponding month on the
x axis. But, my next data point is set a couple of inches over to the right,
several months over from its corresponding month on the x axis. How do I get
the data points to situate themselves over their corresponding month? They
match up in the data sheet.
Thanks..........TomCat

Reply to this Message

David Biddulph - 06 Sep 2007 12:54 GMT

If it's dates you are looking at, are you confident that you haven't got
formats mixed up in terms of days & months? On the datasheet, try
temporarily formatting the cell as something like dd mmm yyyy, so that it
spells out the month name, so that you can see whether 6/9/07 has been
confused with 9/6/07, for example.

Signature

David Biddulph

>I have a simple x-y graph that has manhours on the y axis and months on the
>x
[quoted text clipped - 8 lines]
> match up in the data sheet.
> Thanks..........TomCat

Reply to this Message

TomCat - 06 Sep 2007 13:36 GMT

Thanks for the reply, David. I'll check into that.....TC

> If it's dates you are looking at, are you confident that you haven't got
> formats mixed up in terms of days & months? On the datasheet, try
[quoted text clipped - 13 lines]
> > match up in the data sheet.
> > Thanks..........TomCat

Reply to this Message