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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
Trendline Not Appearing In Chart Problem ? 0
Creating a Chart on form from selected data in query. 0
Create a chart from a table in word thats dynamic 0
Filtered view of Visio Chart 0
Scatter charts for name with two values 0
Creating Network Diagram using a Chart SW integration 0
Average bar charts with individual data points 2

Top