Excel Scatter Plot Data Issues

Occasional Visitor

Hi everyone,

I am having problems with making a scatter plot. I have my X and Y data values in columns next to each other, but when I select that data and click scatter plot, it just shows a single point on the graph. Any idea how to go about fixing this?


1 Reply


Both the x-values and the y-values of a scatter plot must be numbers.

The values in B2:B6 are text values, however. Perhaps you meant to use formulas such as =1/294.8 etc.?