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've set up a Google Spreadsheet to compare one set of stats against another. The stats are for traffic vs. an action the actions only happen once a day and not every day were as the traffic has more volume and happens every day.

What I want to show is a 2 line - line chart with two axis so that I can run the two lines against one another at the moment all I've been able to make is a chart with 2 lines, but both using the same axis - this means that the action line always is sitting at either 0 or 1 were as the traffic line is going up to 30 but there both drawn against the same axis so you cant really read the chart well to see a coloration.

I've linked a copy of the Google Spreadsheet and a mock-up of what I'm trying to achieve here:


share|improve this question

I don't see how your example image relates to your example data because with your data I get:

WA40791 example

but at least the above shows a secondary vertical axis is possible (though only for certain chart types) and it did seem necessary to replace the blanks in your ColumnC with 0.

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.