4

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?

1 Answer 1

6

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

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

You must log in to answer this question.

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