Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I am fairly new at this. When plotting fairly simple XY scattergrams I have
noticed that when y decreases at an increasing rate, the Power trendline Excel yields fits the data with a very high r-square. But when y decreases at a decreasing rate, the resulting trendline fits poorly and the r-square is low. How do I get the trendline (and resulting formula) to "invert" to better fit the data? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
some charts will not show trendlines | Charts and Charting in Excel | |||
how can I change the order of trendlines in a legend? | Charts and Charting in Excel | |||
VBA code to extract m-coefficient in linear trendlines from ALL charts | Excel Discussion (Misc queries) | |||
When and Why Trendlines may not be calculated correctly? | Charts and Charting in Excel | |||
Summing trendlines in excel charts? | Excel Discussion (Misc queries) |