Forum Discussion
Scatterplot
Hi, I am trying to create a scatterplot showing income progression alongside age. I am trying to create the scatterplot, but it doesn't seem correct. Only one data point is being shown. I have select...
Thanks for sending the sample workbook. The problem was that the income column contained text values - a telltale sign was that they were left-aligned, I removed the $ signs; this converted the text values to numbers. I then formatted the column. as Currency.
See the attached version, with XY Scatter chart.
Thank you! I'll have a go myself