Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Answer: How do I set the range of a trend line in Excel?
To set the range of a trend line in Excel, you can follow these steps:
By setting the "Period" value in this way, you should be able to get the trend lines to extend just within the data range for each set of data.
__________________
I am not human. I am an Excel Wizard |
#3
|
|||
|
|||
In a line chart (in any chart with a category axis, in fact), a
trendline covers the entire range of the X axis. If you're able to plot the points on a Scatter chart, the trendline only spans the actual range of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elizabeth wrote: 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. |
#4
|
|||
|
|||
Jon,
Thanks for your help. It is good to know what I can't do it so I stop banging my head trying. Elizabeth "Jon Peltier" wrote: In a line chart (in any chart with a category axis, in fact), a trendline covers the entire range of the X axis. If you're able to plot the points on a Scatter chart, the trendline only spans the actual range of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elizabeth wrote: 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. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the range of a trend line in Excel?
Hi Jon,
I have a user who is trying to make his trend line span only the range of the data, instead of the entire range of the X axis. He is using a Scatter chart. Can you explain how he can do this? We are using Excel 2007. I have been looking for the options, but can't seem to find the right one. Please let me know if you need any further info. Thanks for any help you can provide. "Jon Peltier" wrote: In a line chart (in any chart with a category axis, in fact), a trendline covers the entire range of the X axis. If you're able to plot the points on a Scatter chart, the trendline only spans the actual range of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elizabeth wrote: 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. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the range of a trend line in Excel?
Hi,
As Jon wrote a trendline is based on ALL the data in a series. If you want to trend partial data you will need to create another series that is just the partial data. You can then add your trend line to that series. The series with partial data can be formatted such that it does not shown on the chart by setting the line and marker styles to none. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tammy" wrote in message ... Hi Jon, I have a user who is trying to make his trend line span only the range of the data, instead of the entire range of the X axis. He is using a Scatter chart. Can you explain how he can do this? We are using Excel 2007. I have been looking for the options, but can't seem to find the right one. Please let me know if you need any further info. Thanks for any help you can provide. "Jon Peltier" wrote: In a line chart (in any chart with a category axis, in fact), a trendline covers the entire range of the X axis. If you're able to plot the points on a Scatter chart, the trendline only spans the actual range of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elizabeth wrote: 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. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the range of a trend line in Excel?
Hi Andy,
Thanks so much for your prompt response, I really appreciate it. I will forward the info to my user. Thanks! "Andy Pope" wrote: Hi, As Jon wrote a trendline is based on ALL the data in a series. If you want to trend partial data you will need to create another series that is just the partial data. You can then add your trend line to that series. The series with partial data can be formatted such that it does not shown on the chart by setting the line and marker styles to none. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tammy" wrote in message ... Hi Jon, I have a user who is trying to make his trend line span only the range of the data, instead of the entire range of the X axis. He is using a Scatter chart. Can you explain how he can do this? We are using Excel 2007. I have been looking for the options, but can't seem to find the right one. Please let me know if you need any further info. Thanks for any help you can provide. "Jon Peltier" wrote: In a line chart (in any chart with a category axis, in fact), a trendline covers the entire range of the X axis. If you're able to plot the points on a Scatter chart, the trendline only spans the actual range of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elizabeth wrote: 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. |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the range of a trend line in Excel?
Tammy:
I have several regression posts on my site that may be helpful. Particularly, I have an interactive regression example which lets the user select begin and end points of data subset. I'd suggest you check out this post to see if it fits your needs. http://processtrends.com/toc_trend_a...e_Regr ession Kelly http://processtrends.com "Tammy" wrote in message ... Hi Jon, I have a user who is trying to make his trend line span only the range of the data, instead of the entire range of the X axis. He is using a Scatter chart. Can you explain how he can do this? We are using Excel 2007. I have been looking for the options, but can't seem to find the right one. Please let me know if you need any further info. Thanks for any help you can provide. "Jon Peltier" wrote: In a line chart (in any chart with a category axis, in fact), a trendline covers the entire range of the X axis. If you're able to plot the points on a Scatter chart, the trendline only spans the actual range of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elizabeth wrote: 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. |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set the range of a trend line in Excel?
Hi Kelly,
Thanks so much for providing your helpful article. I will forward that to my user, as well. Thanks, again! :) "Kelly O'Day" wrote: Tammy: I have several regression posts on my site that may be helpful. Particularly, I have an interactive regression example which lets the user select begin and end points of data subset. I'd suggest you check out this post to see if it fits your needs. http://processtrends.com/toc_trend_a...e_Regr ession Kelly http://processtrends.com "Tammy" wrote in message ... Hi Jon, I have a user who is trying to make his trend line span only the range of the data, instead of the entire range of the X axis. He is using a Scatter chart. Can you explain how he can do this? We are using Excel 2007. I have been looking for the options, but can't seem to find the right one. Please let me know if you need any further info. Thanks for any help you can provide. "Jon Peltier" wrote: In a line chart (in any chart with a category axis, in fact), a trendline covers the entire range of the X axis. If you're able to plot the points on a Scatter chart, the trendline only spans the actual range of data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Elizabeth wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
line graphs in excel | Excel Worksheet Functions | |||
mistakes in the Excel functions (help on line french version at le | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Highlight ing of active line within excel | Excel Discussion (Misc queries) | |||
goal line in excel chart | Charts and Charting in Excel |