How can I make a shape chart with connecting lines, or conversely a line chart with shapes at the connecting points? (see attachment).
Yep, under the color menu. Though they are not great - you may want to do a double axis with multiple marks, one set to line, the other set to shape.
Retrieving data ...