how to plot a graph in excel with 2 variables

Often, this will be a statistical summary like a total or average value across events within each bin. On the vertical axis, you will report the value of a second numeric variable for points that fall in each of the intervals defined by the horizontal-axis variable. The choice of interval size, or bin, is a decision that the analyst will usually need to make for the data, rather than it being an inherent data characteristic. Very commonly, this variable is a temporal one, generating an observation every minute, hour, day, week, or month. On the horizontal axis, you need a variable that depicts continuous values that have a regular interval of measurement. This emphasis on patterns of change is sold by line segments moving consistently from left to right and observing the slopes of the lines moving up or down. You will use a line chart when you want to emphasize changes in values for one variable (plotted on the vertical axis) for continuous values of a second variable (plotted on the horizontal). We can read from the general slope of the line and its vertical positions that the rate improved from about 0.75 to 0.78 between March and early April, then fell gradually to about 0.765 in late May and June. As time progresses from left to right, points connect the daily exchange rates. The line chart above shows the exchange rate between two fictional currencies over a six month period. The horizontal axis depicts a continuous progression, often that of time, while the vertical axis reports values for a metric of interest across that progression. A line chart (aka line plot, line graph) uses points connected by line segments from left to right to demonstrate changes in value.

How to plot a graph in excel with 2 variables