Ask Your Question

Equations of Lines on Charts [closed]

asked 2012-03-02 05:57:29 +0100

anonymous user


Is it possible to create a chart that shows data points and an additional (custom) line? Basically, I need to make a scatter plot that shows a specific data set and also a (not exact) line of an exponential equation. I can get it to show the data but I can't figure out if there is a way to add an additional line or not.

Thank you for your help!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 05:23:48.539581

1 Answer

Sort by » oldest newest most voted

answered 2012-03-02 07:44:59 +0100

Pedro gravatar image

updated 2012-03-02 07:45:14 +0100

You can't add a line by specifying a custom equation (you can only fit the trend lines available e.g. linear, logarithmic, etc).

But there is a workaround: create a XY (Scatter) plot where the first series is your point data and the second series is the Y values resulting from applying the custom equation. Choose Point Only (and check the Smooth lines box), then select a point from your second series, right click and Format Data Series, tab Line, Line Style Continuous, Icon No Symbol.

edit flag offensive delete link more

Question Tools


Asked: 2012-03-02 05:57:29 +0100

Seen: 3,201 times

Last updated: Mar 02 '12