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...

    Values

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

    Wizard1

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

    Wizard2

  • 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:

    Wizard3a

    Wizard3b

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

    Chart

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 .