Aug 18 2022 09:15 AM
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.
Aug 18 2022 09:17 AM
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.
Aug 19 2022 03:02 AM
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.