Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For some reason Google Spreadsheet insists on using the data I wish to have for my x-axis as my y-axis. Here I'll show what happens when I try to use my data to form a chart, and what happens when I use Google's example data for creating a line chart.

Here is the image (my data is on the right, example data on the left): enter image description here

share|improve this question

Never mind, I found the solution.

It was because my data was text format (despite changing the formatting many times in the format options). To counteract this I had to make another table which used =VALUE(cell) on each piece of data. This gave me the numerical value allowing me to make graphs successfully.

share|improve this answer
Thanks for posting. – Jacob Jan Tuinstra May 5 '13 at 19:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.