| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how can i find the relation between x & y in chart
how can i find the relation between x & y in chart
|
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how can i find the relation between x & y in chart
On Thu, 15 Mar 2007, in microsoft.public.excel.charting,
nadir said: how can i find the relation between x & y in chart Don't. Find the relation between x and y in the spreadsheet cells instead. Try the SLOPE() and INTERCEPT() functions, and read the help files on the other functions available. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how can i find the relation between x & y in chart
nadir -
Use an XY (Scatter) chart type, not a Line chart type. Click once on a data point to select the data series. Choose Chart | Add Trendline, and select an appropriate linear or nonlinear relationship. - Mike http://www.mikemiddleton.com "nadir" wrote in message ... how can i find the relation between x & y in chart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Picking out a Period, in relation to certain cells | Excel Worksheet Functions | |||
| Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
| Macro Recorder-Relative relation | Excel Discussion (Misc queries) | |||
| Conditional formatting in relation to other cells | Excel Worksheet Functions | |||
| Cell relation ships. | Excel Discussion (Misc queries) | |||
Linear Mode
