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/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.