Scatter chart assistance

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top