LinkBack URL
About LinkBacks
Hi
I need help regarding the trend in excel
I dont know how to do it.
Regards,
Hi
I need help regarding the trend in excel
I dont know how to do it.
Regards,
I think tthat you need to provide MUCH more information on what you have, what you want and you need to provide sample data.
Will you please attach a sample Excel workbook? Please don't attach a picture of one.
1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential information is removed first!!
4. Try to avoid using merged cells. They cause lots of problems!
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Creating the Chart
Enter the data into your Excel spreadsheet. You should have enough data to cover a reasonable period of time, such as two years or more. You should also have consistent intervals, such as weekly, monthly, or yearly entries.
Select the data you want to include in the chart. You can select the data either by using your mouse or by selecting a single cell and pressing the "Ctrl" and "A" keys simultaneously to select all adjacent cells with data in them.
Access the Chart feature. While Excel offers a number of chart options, you'll want to set up a line chart for your trendline.
Remove the chart legend, if desired. The chart legend explains which colors represent which dataset in the chart. Removing the legend offers more space for the chart itself.
Applying a Trendline
Click on the chart. This displays the menus or menu tabs you need to access Excel's trendline features.
Select the data series you wish to have a trend line for. This is necessary only if you have more than one data series on your chart.
Access the trendline feature.
Choose the type of trendline you want. What type of trendline you want depends on how you want to analyze your data. See "Choosing the Right Trendline" for a discussion of the trendline types.
Establish the range you wish to forecast for. You can project a trend forward, backward, or both.
Display the R-squared value, if desired. The R-squared value indicates how closely your trendline follows your data; the closer its value is to 1, the closer it follows your data. To display this value, check the "Display R-squared value on chart" box.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks