X axis doesnt show full data

[LeoWeis]

So as you can see on the picture (hopefully it is attached to this post), my distance data goes until 49, however on the chart/line graph it only goes to 26. How could I change it so it goes to 49?

Thank you very much

[MrShorty]

What type of chart -- line or XY scatter? I would guess that you intend to use an XY scatter chart, but I cannot be certain from this side of the internet.

What are you using for the horizontal/X axis range? Excel charts will usually assume count numbers (1,2,3,...) for the x axis data if you do not specify what to use, which appears to be the case here (you have 26 data points, so it is using 1 to 26 for the x axis data). Be sure you are specifying column A as the horizontal/category/X axis data.

I cannot say for certain from a screenshot, but numbers stored as text within the X axis data range will cause Excel to use count numbers for the X axis data in a scatter chart.