LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Elizabeth
 
Posts: n/a
Default How do I set the range of a trend line in Excel?

I am using excel to create trend lines in a chart. I have four different sets
of data, two sets lie on weeks 1-6, and two sets lie on weeks 7-12 (x-axis).
Right now, I can make individual trend lines for all four sets of data, but
they extend the length of the x-axis (all 12 weeks). How do I get the trend
lines to extend just within the data range? Thanks for any help.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
line graphs in excel karl gauss Excel Worksheet Functions 1 March 17th 05 11:55 AM
mistakes in the Excel functions (help on line french version at le sergeK Excel Worksheet Functions 6 March 11th 05 08:45 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM
Highlight ing of active line within excel glen2351 Excel Discussion (Misc queries) 1 January 4th 05 01:10 PM
goal line in excel chart Warren Lehndorfer Charts and Charting in Excel 1 December 3rd 04 04:38 PM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"