Forum Discussion
arogalla
Dec 01, 2021Copper Contributor
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 ...
HansVogelaar
Dec 01, 2021MVP
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.?