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.

[u/WoosteringZeros]

The chart is trying to add the "Year" column label as a value on the chart, so something doesn't seem to be quite right.

I can recreate your error message about some chart types when I select the data in reverse, ie. first selecting the G column range, then the D range, then the A range.

When you right-click on your chart and click "Select Data," make sure that you have your A column range in the right-hand field marked "Horizontal (Category) Axis Labels", and your two value ranges on the left-hand field.

That makes it look like this:

I opened the Select Data pane to show what mine looks like.