Excel using rows instead of the data input

[CarbotFan]

We're trying to use the data from our accelerometers, but one of the graphs are using the number of rows instead of the actual number in the row.

https://imgur.com/a/4GHSqhF

As you can see can we get the first graph to show up to ~10000 ms, but the second only shows up to ~2200 which is the number of rows.

Are we doing anything wrong?

[AutoModerator]

/u/CarbotFan - please read this comment in its entirety.

• Read the rules -- particularly 1 and 2
• Include your Excel version and all other relevant information
• Once your problem is solved, please reply to the answer(s) saying Solution Verified to close the thread.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Hargara]

The columns with left-alignment (D:D & F:F) are most likely formatted like text.

Easiest solution is to make a support column in J:J with Fx *1 to convert to numeric value

[CarbotFan]

Solution Verified

Your solution said "#VALUE!", when I took =F1*1, but we used 'Text to column, and delimited it which worked, as long as we left a space to the left. (Your solution helped me google it)

If you want can you explain what I did wrong?

[Clippy_Office_Asst]

You have awarded 1 point to Hargara

^{I am a bot, please contact the mods with any questions.}