Note: The figure shows using a chart sub-type that automatically connects data points with smoothed lines. If your data is linear it is better to use a pure scatter plot and add a trend line later.