![]() Please help, I don't know why this is so difficult and every article I read or answer I see just tells me to do exactly what I'm doing. I've also tried to switch the column order before creating the scatter plot and it does something equally crazy (basically puts column A on the x axis and column B on the y axis but then only maps 5 data points. ![]() Next, we will highlight our data and go to the Insert Tab. We will set up our data table as displayed below. I tried Select Data and switching Rows and Columns to see if that helps, but then it just puts both Columns A and B together somehow. We will set up a data table in Column A and B and then using the Scatter chart we will display, modify, and format our X and Y plots. It's like it uses Column A as a title of the point or something but I want it to use its value. ![]() Step 3: Select the desired type of scatter plot. Since scatter graphs are meant to show how two numeric values are related. See photo below for what comes up, I hovered over a data point so you can see it's mapped to Row 1 and then the value in column B. Ensure that your data is in the correct format. However when I select both columns and insert Scatter Plot it uses Column B as the Y axis (great), but then the x axis just seems to correspond to the row # and it totally ignores Column A. Right now I have Column A which I want to make the X axis, and Column B which I want to make the Y axis. ![]() I have two columns that I want to make the X and Y axis of a scatter plot, but it refuses to use both data points. This tutorial shows how to easily draw scatter plots with confidence ellipses in Excel using the XLSTAT software. This seems like it should be the easiest thing and I can't figure it out. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |