Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.