Super User is a question and answer site for computer enthusiasts and power users. 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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .