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 know it is possible to plot graph or chart in Google Spreadsheet.

But the problem with current plotting way is that you can only specify the Y, but not the X. And as such, there is no way to plot a time series graph ( time vs displacement for example).

Any idea on how to do this?

share|improve this question
up vote 4 down vote accepted

This link: http://www.google.com/support/forum/p/Google+Docs/thread?tid=5cea8659f9b3bd29&hl=en

Indicates that there are work arounds allowing you to plot the X and the Y, using a 'hack' to plot dates for example.

share|improve this answer

There is now a "Time Line" Chart option in the Trend category that makes a nice chart like Google Finance. Customization is limited, but the Google Finance style charts are pretty cool.

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.