Is it possible to create a chart with lines connecting the values on a time
axis where there are NOT data points for each time period? For example, 30
days over which only 5 values occur.

When I tried to add a line to a scatter chart nothing happened. I suppose I
could create another series that uses the end points of the first series and
simply fills in the values based on the slope between the two points but I'm
hoping there is a better way.

Many thanks for your assistance.