| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set a trendline for only say the first 25% of the data s.
Hi, I have plotted a logarithmic distribution but only want the trendline to
take into account certain points and not the whole data series. However I don't know how to select only the points I want to use. Any help anyone could give me with this would be great. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set a trendline for only say the first 25% of the data s.
Use a second series on the chart that only contains the data of interest.
Jerry "qwerty" wrote: Hi, I have plotted a logarithmic distribution but only want the trendline to take into account certain points and not the whole data series. However I don't know how to select only the points I want to use. Any help anyone could give me with this would be great. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I set a trendline for only say the first 25% of the data s.
Add a second series to the chart using your "certain" points. Add the trend line to the new series. Format the new series so it can't be seen. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "qwerty" wrote in message Hi, I have plotted a logarithmic distribution but only want the trendline to take into account certain points and not the whole data series. However I don't know how to select only the points I want to use. Any help anyone could give me with this would be great. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| trendline for part of data | Charts and Charting in Excel | |||
| applying st. dev. of a data set to a trendline forcast | Charts and Charting in Excel | |||
| how to draw a trendline using two set of data? | Charts and Charting in Excel | |||
| Trendline Chart Data | Charts and Charting in Excel | |||
| How do I get a trendline for all data series, instead of just one. | Charts and Charting in Excel | |||
Linear Mode
