Plotting partial data sets

[phpistasty]

I'm trying to create a graph of data. It spans multiple years, and doesn't have a consistent x-increment.

Example data:
(2000,#)
(2007,#)
(2008,#)
(2009,#)
(2010,#)

I need to be able to plot the data without assuming the in-between values (non linear growth). I figure there must be a way of doing this without creating functions to calculate estimates. The x-increment needs to correlate with the integer value, so x-axis would be:
2000 ----------------------------------2007---2008---2009---2010

I haven't been able to figure out a way to declare the dataset correctly to 'skip' the unfille rows.

Any help would be much appreciated.

[phpistasty]

Seems another user just posted a similar question

http://www.oooforum.org/forum/viewtopic.phtml?t=141646

Didn't intend to post what seems to be the same question (or similar)

[phpistasty]

I found the missing values option under plot options. This works and does what I intended to do.


The solution is:

Double click to edit the graph.
Double click the line to open the Data Series dialog, and choose 'Continue Line' under Plot options.

[edit]

Still trying to find a way to accomplish this without having to create empty columns.