Scatterplot

Occasional Contributor

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 selected only the income and age columns, so I do not understand why this is happening.

3 Replies

@Taii36 

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.

@Taii36 

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