Scatter chart assistance
 

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?

Scatter chart assistance
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dvrhodes" wrote in message
...
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?