If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scatter Chart
How to get Y-axis value from scatter chart if we know X value
|
#2
|
|||
|
|||
If your X values are in A2:A10 and your Y values are in B2:B10, and if
your known X value is in C1, this formula will provide the Y value along the least squares fitted line: =INTERCEPT(B2:B10,A2:A10)+SLOPE(B2:B10,A2:A10)*C1 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Chintan Shah wrote: How to get Y-axis value from scatter chart if we know X value |
#3
|
|||
|
|||
In addition to Jon's suggestion, you might also want to look at
Read Chart Value http://www.tushar-mehta.com/excel/ti...lue/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , =?Utf- 8?B?Q2hpbnRhbiBTaGFo?= Chintan says... How to get Y-axis value from scatter chart if we know X value |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |
'Closing' chart window *and* removing chart using VBA | Marc R. Bertrand | Charts and Charting | 7 | December 17th, 2003 04:30 PM |
Help ! Scatter Chart plots wrongly ! | Jon Peltier | Charts and Charting | 2 | November 19th, 2003 12:57 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |