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.

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

1 Answer

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