Selecting data points in a scatter chart

A

Anthony Blackburn

I am making a scatter chart. I want to put a trend line in it, but I can't
seem to select all of the datapoints in the chart. I right click on a
datapoint and only a few are selected.

How do I make a trendline based on ALL of the scatter shot data points?

Thanks
 
L

Luke M

Make sure all your scatter points you want a trendline for are in the same
series. XL can't create trendline across randomly selected points. Then you
can select the series, right-click, create trendline.
 
J

Joel

If you are not getting all the poits then you probably have more than one
series. the Trendline will only work on a single series. You would have to
add a seperate trendline for each series.
 
Top