Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-24-2015, 06:57 AM
tinfanide tinfanide is offline Interception between trendline and markers? Windows 7 64bit Interception between trendline and markers? Office 2010 32bit
Expert
Interception between trendline and markers?
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

Quote:
Originally Posted by gebobs View Post
The y-intercept is part of the equation. The x-intercept can be derived from the equation by setting y=0. Is that what you want?
Well, it seems that I haven't got my question across.
On the chart, there is the x-y equation which is automatically generated in making the scatter chart.

However, we cannot take out the x-y equation. If I want to use it in a cell, I have to manually type the x-y equation provided on the chart (e.g. y = 0.548x + 1.369) in that cell.

But anyway, it seems that I've found a solution. In that cell, I manually type an equation:

y = mx + b
where m = slope and b = interception

and that equation is the same to that generated from the scatter chart.

However, a question is still unanswered. That is - how can I get the interception between the markers and the trendline on the scatter chart?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Linear trendline? markg2 Excel 0 06-25-2015 05:19 AM
2 different indent markers mekd PowerPoint 0 10-12-2013 06:59 AM
Chart Markers on PPT zymolysis PowerPoint 0 06-21-2012 07:54 PM
Interception between trendline and markers? Can't get rid of Margin Markers and need to get rid of them APohlmeyer Word 1 12-21-2011 04:06 PM
Interception between trendline and markers? Additional Markers in 2010(?) judicial85 Excel 5 09-26-2011 08:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft