![how to plot a graph in excel with two point how to plot a graph in excel with two point](https://images.saymedia-content.com/.image/c_limit%2Ccs_srgb%2Cq_auto:good%2Cw_700/MTc1MDE0NjM3OTkyMjI0NDg4/how-to-create-a-scatter-plot-in-excel.png)
Plot Coordinates in Excel Using Error Bars We could also use this method for multiple x/y pairs also:
![how to plot a graph in excel with two point how to plot a graph in excel with two point](https://www.qimacros.com/scatter-plot-excel/quadrant-graph.png)
#HOW TO PLOT A GRAPH IN EXCEL WITH TWO POINT UPDATE#
So if the desired x-value is updated, the horizontal and vertical markers update as well. Of course, since it’s a chart series it automatically updates. Then we can add a data label and change the horizontal and vertical lines to dashed lines for better readability: So if we start with the data from our table of air density and temperature, then add a second series with those pairs of data (using a scatter plot with straight lines and markers), we get the following: The first and second pair of data points comprise the horizontal line from the y-axis to (x-value, y-value) and the second and third points make up the vertical line extending upward from the x-axis. The lines extending from the x- and y-axes to the interpolated point (x-value, y-value) can be created with a new data series containing three pairs of xy data. It would be nice to know where that data point falls on the x- and y-axes, so let’s look at one of the ways to do that: Plot XY Coordinates in Excel by Creating a New Series The intermediate green point on the line was interpolated from the available data. In the scatter chart below, the blue line represents the available data points.
![how to plot a graph in excel with two point how to plot a graph in excel with two point](https://bsuite365.com/blog/wp-content/uploads/difference-between-scatter-and-line-charts-1024x512.png)
As an example, I’ll use the air temperature and density data that I used to demonstrate linear interpolation. If you have a scatter plot and you want to highlight the position of a particular data point on the x- and y-axes, you can accomplish this in two different ways.