Trendline

L

livelovelaugho0o

Version: 2008

Is there a way to change the slope of the trendline so that it intersects with a certain point on the graph? I have it starting at 0 but I don't know how to move it so that it intersects where I want it to. Also, is there a way to create a trendline that starts in the x-axis instead of the y-axis?
 
M

Mike Middleton

livelovelaugho0o -

If you use an XY (Scatter) chart type, you can enter data for two points
(i.e., two XY pairs) in a worksheet to specify the endpoints of any straight
line, and then you can add that data series to your existing chart,
formatting the new data series to have line connectors.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel
 

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

Trendline Not Appearing In Chart Problem ? 0
Sr. Citizen Question On Adding A Trendline, Please ? 1
Remove Trendline 3
Trendline problems 3
Trendline Showing Problem ? 3
logarithmic trendlines using zero values 2
Decimal places on trendline 1
Add a trendline 2

Top