Incorrect data – Google sheets

  • Resolved oliversm

    (@oliversm)


    2 years, 3 months ago

    Hi there,

    I am using the free version and trying to create a line graph showing maximum daily speeds recorded from August to December 2021.

    I am using this Google Sheet to import the data from, column A has the data and column B has the maximum speed logged for that day.

    Tha chart seems to have more than one series line and the dates on the y axis are not per my data imported from the sheet.

    Image of the chart here. (Give it a few seconds to load!)

    Can somebody suggest what I might be missing here?

    Thanks ??

    • This topic was modified 2 years, 3 months ago by oliversm. Reason: Incorrect URL in link
    • This topic was modified 2 years, 3 months ago by oliversm.
    • This topic was modified 2 years, 3 months ago by oliversm.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Poonam Namdev

    (@poonam9)

    Hello @oliversm,

    Sorry for the delay in response.

    I have checked the Google sheet you linked in your message. It doesn’t have data types defined in the second row, and some numbers appear on the last line. Please remove them. Screenshot >> https://vertis.d.pr/i/jScNg2

    I have used your data to create a line chart, and it works fine. Please add datatypes as shown in this screenshot >> https://vertis.d.pr/i/f3I5Ed.

    Hope it helps and let me know if you require any further assistance.

    Thread Starter oliversm

    (@oliversm)

    Hi there,

    Thank you very much for your support.

    The sheet did have the data types defined when I tested but I took them out and used another method for the graphs. I think the problem was all the extra data at the bottom which you spotted. I’m not sure where that came from or why I missed it!

    Thank you for helping and I will use Visualizer on my site soon, it seems to be working well now. ??

    Plugin Support Poonam Namdev

    (@poonam9)

    Hi @oliversm,

    I am glad to hear that you got it working.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Incorrect data – Google sheets’ is closed to new replies.