Try this it may work
1) Display the equation of the line.
2) use the equation to calculate the value y by taking x as 0.0000001 or any
value
3) add these values (x,y) to your series as new points

you can then hide the marker if you want.


Hope this helps

"Bill" wrote:

I have done that, but it is not working. Perhaps it is because I am plotting
a log-log graph and therefore there is no actual zero value for the y-axis.
But I need the line to pass through the origin, and because the data covers
several decades, it needs to be plotted as log-log. Any ideas?

Bill

"Bernard Liengme" wrote:

Yes, open at the Option tab when you make (or format) a trendline
There is a text box to set intercept to any value (including 0)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bill" wrote in message
...