how to plot a graph in excel with 2 differednt y and x

In these cases, we want to know, if we were given a particular horizontal value, what a good prediction would be for the vertical value.

Identification of correlational relationships are common with scatter plots. The dots in a scatter plot not only report the values of individual data points, but also patterns when the data are taken as a whole.

Scatter plots’ primary uses are to observe and show relationships between two numeric variables. This tree appears fairly short for its girth, which might warrant further investigation. We can also observe an outlier point, a tree that has a much larger diameter than the others. From the plot, we can see a generally tight positive correlation between a tree’s diameter and its height. Each dot represents a single tree each point’s horizontal position indicates that tree’s diameter (in centimeters) and the vertical position indicates that tree’s height (in meters). The example scatter plot above shows the diameters and heights for a sample of fictional trees. Scatter plots are used to observe relationships between variables. The position of each dot on the horizontal and vertical axis indicates values for an individual data point. Make sure to download the Excel file that accompanies this tutorial to see this example in the spreadsheet.A scatter plot (aka scatter chart, scatter graph) uses dots to represent values for two different numeric variables. That is because Excel will guess what you want the starting unit to be for the Y axis and it doesn't always know what you want. This is a simple yet important thing to know how to do in Excel. Note: You can start the Y axis at any number instead of typing a zero for step 3, input the desired number. (If your window doesn't look like this, make sure you have selected the Axis Options category from the left side of the Format Axis window) Look to the top and next to where it says Minimum click the circle for Fixed and enter a 0 (zero).

You will now be in the Format Axis window.

Click the Axes button and go to Primary Vertical Axis and then More Primary Vertical Axis Options.

Select the Chart and go to the Layout tab (that is visible only when you select a chart).How to make the Y axis start at 0 in charts in Excel.

How to plot a graph in excel with 2 differednt y and x