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 am trying to graph the temperature of a substance versus the time the substance has been heated.

My data is as follows:

      A         |        B
Time (Minutes)  | Temperature (ºC)
0               | 22.8
.5              | 24.5
1               | 32.2
1.5             | 37.8

When I select the two columns and choose Insert -> Graph, it puts both of them on the same axis.

"Use column B as labels" is an option but I want to use column A. How can I do this?

share|improve this question

This could be because one your columns is formatted as plain text, not as numbers. This restricts the roles of axes, as text values are automatically assumed to be labels.

Using the input from your example, with both columns formatted as numbers, I have no problem using Column A as labels:


share|improve this answer

switch the values and then the option "use column B as labels" will be right.

share|improve this answer
Welcome to Web Applications Stack Exchange. You would need to elaborate on this for it to be a good answer. It is also useful to set up an example spreadsheet and link to it from your answer. – Vidar S. Ramdal Nov 13 '13 at 13:35

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.