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

I've got a time series data table with one function (row) value available for every month and the second for every 3rd month (every quarter), having holes (empty cell values) for every 2nd and 1st months of a quarter.

When I try to make a chart, I can only draw a bar or a point chart, but I want the actual data points to be interconnected with lines visually filling the gaps.

How to achieve this in LibreOffice 3.6?

share|improve this question

First, make sure you've selected a chart type that allows for drawing lines: Area, Line, XY (Scatter) or Columns and Lines.

Now, create your chart as usual. After you've finished it, do a single-click on the line of the incomplete data series (the data points now should be green). Now, do a right-click on that line, and from the context menu, select "Format Data Series".

In the "Format Data series" dialog, under "Plot Options", select "Continue line". Other Options are: "Leave gap" and "Assume Zero":

Format Data Series

share|improve this answer
If I choose a line chart style (not points-and-line), it just draws nothing, so, nothing to click at. – Ivan Sep 18 '12 at 22:35
What about inserting some dummy data to get a line, modify it, and remove the dummy data afterwards? – tohuwawohu Sep 22 '12 at 9:29

You must log in to answer this question.

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