Data point on line is not over the point/tick in X axis...
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 |
Data point on line is not over the point/tick in X axis...
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. -- David Biddulph "TomCat" wrote in message ... 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 |
Data point on line is not over the point/tick in X axis...
Thanks for the reply, David. I'll check into that.....TC
"David Biddulph" wrote: 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. -- David Biddulph "TomCat" wrote in message ... 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 |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com