LinkBack URL
About LinkBacks
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
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
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.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks