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


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.


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