You can add curves and other drawing objects only to a chart. You cannot add them to the datasheet.
To close the shape, click near its starting point.
Tip After you complete a curve, you can close an open shape or open a closed one. Right-click the curve, and then click Close Curve or Open Curve on the shortcut menu.