Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.