# Questions tagged [trendlines]

The tag has no usage guidance.

18 questions
Filter by
Sorted by
Tagged with
0answers
28 views

### How to make best fit line that is weighted according to precision of each data point

I have got a set of experimental data calledxdata and ydata that I want to approximate with a trend line. Traditionally, Libreoffice Calc calculates the optimal trend line using a method which gives ...
1answer
57 views

### Excel 2010 - Creating a line graph for trend analysis of faults

I have an excel spreadsheet that currently tracks fault reporting in our building. I am looking to do some form of trend analysis ideally to track the faults on the spreadsheet and then display them (...
0answers
953 views

### Highlight/Select specific data points on excel chart to draw a trend line

I hope I can get some help with the problem that I'm trying to solve. I want to be able to chart some stock data using excel. I have that part done. I have 3 columns (date, high, low, close). I am ...
3answers
35k views

### Get coordinates of intersecting point of two trend lines

Given this table, chart and trend lines in Excel. I want to find the coordinates of the intersecting point. How can I do this?
1answer
19k views

### Multiple Trend Lines for Different Segments of the Same Series in Excel

So I have a set of data in Excel that follows a periodic (roughly sawtooth shaped) pattern over time. That is, it increases gradually over a long period of time, and suddenly drops back down to a ...
1answer
8k views

### How to find trendline without graphing

I have set of data in Excel for which I would like to find the trendline. Is there a way to find the trendline (linear and non-linear) from the raw data? Or do I have to graph the data and use the ...
3answers
5k views

### Higher Dimensional Trendline

My data is in multiple dimensions, as below. Rather than a trendline, I guess I need a trendplane. Is this possible in Excel or a similar tool?
1answer
1k views

### How to antialias trendline in Excel?

I have created a couple of line charts in Excel 2011 for Mac. The actual data line looks good and is antialiased in a nice way but when I then add a trendline it is jagged and ugly: I have tried "all"...
1answer
418 views

### Excel - Reuse a trend line to apply to other data

I've obtained a trend line from a particular set of data. What I'd like to do now is to reuse this trend line to predict values from a given pair (x,y) of coordinates. To put it another way, I have ...
0answers
842 views

### Trendline not printing

I have many pages with similar graphs and data tables to print. And there is one page that does not print the trendline in the graph. I reloaded the file and tried printing it which worked out, then i ...
1answer
6k views

### LINEST function in excel vba

I am trying to figure out the 2 order equation (Y = ax^2 + bx + c) for a set of data values. When I use the inbuilt function in excel =LINEST(C2533:C2537,B2533:B2537^{1,2}) I get the following ...
1answer
1k views

### Office Excel Linear Approximation is Inaccurate

I am doing a physics project. I have made experiments with free-fall, and I have a time-velocity graph which I built. The slope of each point in the graph is the acceleration. The acceleration in free-...
1answer
2k views

### track disk usage over time in linux

I know I can use df to get a summary of disk usage right now. I can use du to break down into the detail of how the disk is being used. The problem is I can only see this information for today. ...
1answer
871 views

### Any way to make interactive graphs in LibreOffice like Google Doc's Trend chart?

Google Docs has a nice trend viewer that can be created just like any other chart: Is there any way to get an interactive graphic like this in OpenOffice? Manually adjusting the axes is really ...
3answers
22k views

### Use a Trendline Formula to Get Values for Any Given X with Excel

Is there an easy way to apply the trend line formula from a chart to any given X value in Excel? For example, I want to get the Y value for a given X = \$2,006.00. I've already taken the formula and ...
3answers
5k views

### Excel trendline accuracy

This is a problem I have every once in a while, and it annoys me tremendously, beacuse I have always to recheck every trendline I get. An example: r L (mm) 30,00 97,0 60,00 103,2 ...
1answer
929 views

### Is there a program to calculate fibonacci charts and their continuations? [closed]

I'd need a program able to take data and plot a trend graph, and it should be able to continue it to see the future trend. I've found some commercial programs but none work. Is there a free one? I ...
2answers
1k views

### Apart from visually inspecting the graph, is there a way of calculating when a trend line will cross another series?

Is there a way to find the point of intersection of a trend line and another series on a chart in Excel? The other series may be another trend line or just the interpolated line drawn by Excel.