Custom Trendlines y=x

Giganews Newsgroups
Subject: Custom Trendlines y=x
Posted by:  miss*m (missm.29tusn_1151019601.5478@excelforum-nospam.com)
Date: Thu, 22 Jun 2006

Hi guys,

I'm trying to add a custom trednline to some data and for some reason
its not working. I want a y=x line that goes through my data and not a
line of best fit. No matter what I do, I am only getting a line of best
fit.

What I want:
A y=x line that goes through the point (0,0).

What I'm doing:
Type in Y=x in custom. and ofcourse select custom and tick set
intercept y=0.

Please oh please help!!!

Thanks in advance!

--
miss*m
------------------------------------------------------------------------
miss*m's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=28430
View this thread:http://www.excelforum.com/showthread.php?threadid=554798

Replies