DannE Posted November 26, 2007 Report Share Posted November 26, 2007 The line graphs are shifted to the left by one year and so the last year, 2007, doesn't show. I have attached the project, which contains the graph that I got and a comma seprated file for the data. Please provide any suggestions Quote Link to comment Share on other sites More sharing options...
DannE Posted November 26, 2007 Author Report Share Posted November 26, 2007 I get the correct graph if I use excel i.e. data is not shifted by one year to the left Quote Link to comment Share on other sites More sharing options...
maximop Posted November 28, 2007 Report Share Posted November 28, 2007 You currently have the Chart1.AxisX.Step property set to show the XValues every two years; since you are starting on 1964, the last year shown based on your settings will be 2006. Try adjusting the Step property to show all years instead. Quote Link to comment Share on other sites More sharing options...
DannE Posted November 28, 2007 Author Report Share Posted November 28, 2007 Yes, I understand why 2007 doesnt show But if you look at the graph and try to figure out, manually, where Nov 2007 might be on the X-axis then the last data point will approximately correspond to 2007 January (by looking at the size of interval between two years and approximating ). However, in the dataset the last datapoint is Nov 2007. If its not clear what I am saying then please look at the attached graph Quote Link to comment Share on other sites More sharing options...
Frank Posted November 28, 2007 Report Share Posted November 28, 2007 The tickmark at 2006 corresponds to the last day of 2006. Quote Link to comment Share on other sites More sharing options...
DannE Posted November 29, 2007 Author Report Share Posted November 29, 2007 Thanks, that makes sense. Have another question, is there any particular reason why the last date on the x-axis wouldn't show, as shown in the attachment. I am not setting any property that would make it do that. Quote Link to comment Share on other sites More sharing options...
Frank Posted November 29, 2007 Report Share Posted November 29, 2007 Looks like there isn't enough room between the tickmarks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.