Line graphs offset

[DannE]

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

[DannE]

I get the correct graph if I use excel i.e. data is not shifted by one year to the left

[maximop]

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.

[DannE]

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

[Frank]

The tickmark at 2006 corresponds to the last day of 2006.

[DannE]

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.

[Frank]

Looks like there isn't enough room between the tickmarks.