| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trend lines on data subsets
Hello,
How do I create trend lines on subsets of data in an Excel (Home and Business 2010) graph? I have data over dates ranging from 1976 through 2010, and I want separate trend lines on the data from 1976-1990, from 1990-2005, and from 2005-2010, all without breaking up the single flow of data from '76-'10. Also: Merry Christmas Thanks Eric Hines |
|
#2
|
|||
|
|||
|
Adding trend lines to Excel charts can highlight significant changes in that involve times series plots with multiple trend lines on the same data.
doctors excuse |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Trend lines on data subsets
eehi wrote on 12/25/2012 10:37 ET :
Hello, How do I create trend lines on subsets of data in an Excel (Home and Business 2010) graph? I have data over dates ranging from 1976 through 2010, and I want separate trend lines on the data from 1976-1990, from 1990-2005, and from 2005-2010, all without breaking up the single flow of data from '76-'10. Also: Merry Christmas Thanks Eric Hines Indeed. Which is why "I want separate trend lines on the data from 1976-1990, from 1990-2005, and from 2005-2010, all without breaking up the single flow of data from '76-'10." Any ideas on how to do that? Thanks Eric Hines |
| 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 | |||
| create chart from daily data and add trend lines for each week | Excel Discussion (Misc queries) | |||
| linear trend lines do not appear gaps in data | Charts and Charting in Excel | |||
| Trend Lines help | Charts and Charting in Excel | |||
| Trend Lines | Charts and Charting in Excel | |||
Hybrid Mode
