Forum Discussion
Excel Scatter Plot Data Issues
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?
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.?
