Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a line graph with 3 lines, 1 for each year 2004-2006. X values are
the weeks in the year and y values are the units of inventory. I want to add a linear trendline for each of the 3 years but only starting from week 29 or 30 (where the line started to go up again). Is that possible? |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
bjw -
The usual solution is to add three more data series to the chart, each with the weeks of interest, add a trendline to each of the new data series, and format each of the new data series to not show markers or lines. If you have difficulty selecting a new data series, select any object on the chart, and use the arrow keys to make the selection. - Mike http://www.mikemiddleton.com "bjw" wrote in message ... I have a line graph with 3 lines, 1 for each year 2004-2006. X values are the weeks in the year and y values are the units of inventory. I want to add a linear trendline for each of the 3 years but only starting from week 29 or 30 (where the line started to go up again). Is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel graphs won't update | Charts and Charting in Excel | |||
Pasting Graphs - making me crazy! | Excel Discussion (Misc queries) | |||
HYPERLINK GRAPHS | Charts and Charting in Excel | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Copying Charts and graphs to another worksheet with formulas | Excel Worksheet Functions |