I would like what seems like a really simple scatter plot in Excel but I cannot find a way to do it without a lot of manual entering. I must be missing something because it seems such an obvious function for Excel to do and I also can't see previous problems like this. You help would be appreciated. Thank you.
- I have 42 rows of data. Column B contains the name of each series. Col C is the Y variable, Col D the X variable.
- Excel won't plot this automatically, even by switching rows and columns because it doesn't understand that each series only has 1 X and 1Y coordinate.