| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
constant in chart
I have a chart of how two values follow each other. Simple. I have the
correlation of the two numbers on the worksheet with the values. I would like to have that show on the worksheet with the chart, which is on it's own page, but I don't want to chart the standard percentage from the correlation function. Ideas? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
constant in chart
Have you looked at the SLOPE and INTERCEPT functions?
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "tylermdsm" wrote in message ... I have a chart of how two values follow each other. Simple. I have the correlation of the two numbers on the worksheet with the values. I would like to have that show on the worksheet with the chart, which is on it's own page, but I don't want to chart the standard percentage from the correlation function. Ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| constant value in a chart | Charts and Charting in Excel | |||
| Constant loan payments vs. constant payments of principal | Excel Worksheet Functions | |||
| updateable constant? | Excel Discussion (Misc queries) | |||
| Constant | Excel Discussion (Misc queries) | |||
| Constant? in VBA | Excel Discussion (Misc queries) | |||
Linear Mode
