Scatter chart assistance

[dvrhodes]

I'm running into a few problems with building a scatter chart.

1. After I select the data, it shows as only 1 point on the chart.

2. At one time, the chart displayed all the points, but when I added a trend
line, it drew a line from the first point and put all the remaining points in
one place to the far right.

3. I have a list of years that I am drawing data from, but not all the years
have data. What would be the best way to enter the cell references. List all
the cells? Or list just the cells that contain the data?

 

[Bernard Liengme]

Enter all the years for the x-values and where there is no data for the
y-values enter =NA() (this will display as #N/A; the chart engine will
ignore these entries)
best wishes