Problem with the scatterplot function in Excel

[u/Any_Blacksmith_8179]

For an assignment, I was tasked to create an excel scatterplot of some sample data. When I try to create a scatterplot using multiple cells as if to distribute data points for two subjects, I get an error. In addition, if I limit the graph to just one subject I get a weird series of labels on the x-axis and no points actually appear on the graph. How can I fix this problem so that I can properly graph the data distribution for one subject and create a graph so that the data distribution for subject one and two are shown.

[u/AutoModerator]

/u/Any_Blacksmith_8179 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.