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

I have a Google spreadsheet with measurements made at different dates. How can I make a chart with the dates spread along the x axis properly? The data looks like this

2010-09-01 80
2010-09-02 79
2010-09-10 81

I want the points that make up the data to be laid out so that the first date is at x0, second date at x0 + 1 and the third date at x0 + 9. So far I have only been able to produce graphs where the first date is at x0, the second at x0 + 1 and the third at x0 + 2.

I must be missing something here. Any tips appreciated!

share|improve this question
up vote 2 down vote accepted

It seems that this is possible to do in a Google spreadsheet now.

If I enter the data from my question, highlight it and select insert chart from the menu, Google Spreadsheet will greate a trend graph with the points laid out correctly.

share|improve this answer

It looks like it's still not yet possible with Google spreadsheets.

Look at the thread on google's support forum for tips and updates

Google Forums - date in a chart

share|improve this answer

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.