Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Samantha
 
Posts: n/a
Default how to add data points to a scatter plot with trend line

I want to add data points to the scatter plot that are not part of the data
ie. add points to find their concentration on a standard curve.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: how to add data points to a scatter plot with trend line

Steps to add data points to a scatter plot with a trend line in Microsoft Excel:
  1. Create your scatter plot with the existing data points. To do this, select the data you want to plot, including the x-axis and y-axis values. Then, go to the "Insert" tab and select "Scatter" from the chart options.
  2. Add a trend line by right-clicking on any data point and selecting "Add Trendline" from the drop-down menu.
  3. In the "Format Trendline" pane that appears on the right side of the screen, select the "Options" tab. Under "Forecast," you can choose how far into the future you want the trend line to extend.
  4. Add your new data points to the scatter plot by entering them into the worksheet as additional rows of data. Make sure to include both the x-axis and y-axis values for each point.
  5. Once you have entered your new data points, they should automatically appear on the scatter plot. If they don't, you may need to adjust the axis scales to make sure they are visible.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

You can add another series to the graph. While editing the graph,

Select Chart - Source Data - Series
Select ADD under the series window and enter the name and the X and Y values
for the series.

There are other ways to do this, as well.


"Samantha" wrote in message
...
I want to add data points to the scatter plot that are not part of the data
ie. add points to find their concentration on a standard curve.



  #4   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

The intent of your question is not entirely clear, as evidenced by
different interpretations by different responders.

If you click on the the plotted data series, the formula bar will
display the range of data plotted. If you extend that range in the
formula bar, you can add support x-values to visually extrapolate the
trendline beyond the data. Note however that when the mouse cursor
floats over the graph, y-values will be displayed only for actual x-y
data points in the graph, not for interpolated/extrapolated points on
the trendline.

If you right click on the trendline, and select Format Trendline, you
can go to the Options tab and request that the equation be displayed.
If you format that equation to display in scientific notation with 14
decimal places (to ensure that coefficient values are not obscured
through rounding) then you can calculate y-values for any x-values that
you desire. Alternately, most trendlies can be recalculated using
LINEST or LOGEST.

Jerry

Samantha wrote:

I want to add data points to the scatter plot that are not part of the data
ie. add points to find their concentration on a standard curve.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple scatter graphes how to plot 3 sets of data for x y on th. frances Charts and Charting in Excel 3 May 2nd 23 11:42 AM
Data Points in Scatter Chart CWILSON Charts and Charting in Excel 2 January 25th 05 05:41 PM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 06:15 AM
creating names for data shown on a scatter plot budski Charts and Charting in Excel 1 December 22nd 04 06:15 PM
How many data points can you have in an Excel for a Scatter Chart. gregran Charts and Charting in Excel 3 December 10th 04 08:31 PM


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"