How do I create a connected line graph using style sheets?

macro · Unread post by **macro** » Tue Sep 08, 2015 5:19 pm

My data are in example.xlsx. These are daily data with significant amounts of missing data, formatted as a daily time series. I'm trying to create a graph like the one shown in example.png (hastily made in Excel).

: example.png (9.87 KiB) Viewed 5633 times

Basically, the graph has a marker of a given size and shape for each data point, with a straight line connecting them. Is there a way to create this graph using the predefined graph styles (or a custom style sheet), or do I need to linearly interpolate between each data point and graph the series with the data points as symbols over the line graph of the interpolated values?