Title: Incorrect data – Google sheets
Last modified: November 26, 2022

---

# Incorrect data – Google sheets

 *  Resolved [oliversm](https://wordpress.org/support/users/oliversm/)
 * (@oliversm)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/incorrect-data-google-sheets/)
 * 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](https://docs.google.com/spreadsheets/d/e/2PACX-1vS_aAU8Aqt2QI54Guu6wQq-P5ExvNvLcA0tfqiOxYjYKZN7vDT5uJqTuixPvvQqVwioj-sgr48OE97P/pubhtml?gid=0&single=true)
   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](https://nextcloud.thecobwebs.duckdns.org/s/BmtQiY5Q7MY76HD).(
   Give it a few seconds to load!)
 * Can somebody suggest what I might be missing here?
 * Thanks 😉
    -  This topic was modified 3 years, 6 months ago by [oliversm](https://wordpress.org/support/users/oliversm/).
      Reason: Incorrect URL in link
    -  This topic was modified 3 years, 6 months ago by [oliversm](https://wordpress.org/support/users/oliversm/).
    -  This topic was modified 3 years, 6 months ago by [oliversm](https://wordpress.org/support/users/oliversm/).

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Support [Poonam Namdev](https://wordpress.org/support/users/poonam9/)
 * (@poonam9)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/incorrect-data-google-sheets/#post-16264485)
 * Hello [@oliversm](https://wordpress.org/support/users/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](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](https://vertis.d.pr/i/f3I5Ed).
 * Hope it helps and let me know if you require any further assistance.
 *  Thread Starter [oliversm](https://wordpress.org/support/users/oliversm/)
 * (@oliversm)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/incorrect-data-google-sheets/#post-16292228)
 * 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](https://wordpress.org/support/users/poonam9/)
 * (@poonam9)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/incorrect-data-google-sheets/#post-16312572)
 * Hi [@oliversm](https://wordpress.org/support/users/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.

 * ![](https://ps.w.org/visualizer/assets/icon-256x256.gif?rev=3084574)
 * [Visualizer: Tables and Charts Manager for WordPress](https://wordpress.org/plugins/visualizer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/visualizer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/visualizer/)
 * [Active Topics](https://wordpress.org/support/plugin/visualizer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/visualizer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/visualizer/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Poonam Namdev](https://wordpress.org/support/users/poonam9/)
 * Last activity: [3 years, 5 months ago](https://wordpress.org/support/topic/incorrect-data-google-sheets/#post-16312572)
 * Status: resolved