Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 6th 07, 12:10 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 34
Default 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

  #2   Report Post  
Old September 6th 07, 12:54 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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



  #3   Report Post  
Old September 6th 07, 01:36 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 34
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving a line chart data point revises data table value in Excel ' Ed Smith Charts and Charting in Excel 2 November 16th 12 02:03 PM
Y2 Axis Labels on Y1 Data Point Brad K. Charts and Charting in Excel 1 June 7th 07 08:38 PM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 06:00 PM
Height (in points) of data point in chart above x-axis Scott P Charts and Charting in Excel 5 November 13th 05 02:56 AM
X Axis Labels every 96th Data Point JonMulder Charts and Charting in Excel 1 May 29th 05 03:58 PM


All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017