| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
linear trend lines do not appear gaps in data
Linear trend lines will not appear when specified. I have a few gaps in my
data. I suspect that is why they will not work. Can anyone verify this limitation and/or tell me how to get around it. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
linear trend lines do not appear gaps in data
Hi,
Gaps in your data should not stop you from being able to add a trendline. Where version of excel are you using? What chart type do you have. Note that none of the 3d effects charts allow for trend lines. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "wirepusher" wrote in message ... Linear trend lines will not appear when specified. I have a few gaps in my data. I suspect that is why they will not work. Can anyone verify this limitation and/or tell me how to get around it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to draw trend lines through only certain data points | Charts and Charting in Excel | |||
| A formula that autofills by trend rather than linear | Excel Discussion (Misc queries) | |||
| Linear Regression using the TREND function | Excel Worksheet Functions | |||
| Discontinuous lines in series due to gaps in data points | Charts and Charting in Excel | |||
| How do I anchor one end of a linear trend line? | Charts and Charting in Excel | |||
Linear Mode
