So this short process of connecting the curved line between data points in excels must be performed every time a line or scatter chart is made. There is no preference option to ensure all data points are connected automatically by excel when a scatter or line chart is created. This option now applies to the chart so any additional data or data removed will be automatically updated. The lines between the data points will be updated and connected. On the Select Data Source window click on the “hidden or empty cells” button located on the bottom left of the window.Ĭlick the “connect data points with a line” radar button.
#How to plot a graph in excel with two point how to#
This guide will show you how to connect these data points.
![how to plot a graph in excel with two point how to plot a graph in excel with two point](https://i.ytimg.com/vi/hg8zkt_GUM8/maxresdefault.jpg)
When the scatter plot (or line plot) is created based on the data there are large gaps in the data lines. The example below shows two batches with sporadic weekly measurements. This guide will demonstrate how to change a line or scatter chart with missing data lines due to non data or blank cells into a connected line or scatter chart. In most case the second option, with the connecting line, is the most useful.