Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Is it possible in OpenOffice Calc to create a single chart where one set of data is derived from columns, and another set of data is derived from rows?

share|improve this question
up vote 1 down vote accepted

Yes, this is possible (i tested it with LibreOffice 3.5 - but i'm sure it works the same way with OpenOffice):

  • Starting with these values...


  • Select cells A1:B5, add chart, select "Line" type, select "Points and Lines" style (should work with other chart types and styles, too):


  • In the next step, select "Data series in columns", both First Row / First Column as label:


  • Next step is most important: in the next wizard window, add the second data series manually. To do so, hit the Add button and set Name and Y-Values manually:



  • Now, hit Finish. The result will look similar to this:


The only limitation is that you can't set differenct captions for the different Y axis values - in my example, you will have to decide to use either A2:A5 or B7:E7.

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.