![]() 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. This will replace the column bar for Brand A by a dot at 1 on the. 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. Change the chart type for Brand A from Clustered Column to Scatter and click on the OK button. 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. It's like it uses Column A as a title of the point or something but I want it to use its value. ![]() 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. ![]() 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 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 |