# Questions tagged [trendlines]

The trendlines tag has no usage guidance.

18
questions

**0**

votes

**0**answers

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 ...

**0**

votes

**1**answer

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 (...

**1**

vote

**0**answers

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 ...

**3**

votes

**3**answers

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?

**2**

votes

**1**answer

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 ...

**0**

votes

**1**answer

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 ...

**1**

vote

**3**answers

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?

**4**

votes

**1**answer

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"...

**1**

vote

**1**answer

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 ...

**0**

votes

**0**answers

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 ...

**1**

vote

**1**answer

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 ...

**1**

vote

**1**answer

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-...

**3**

votes

**1**answer

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.
...

**2**

votes

**1**answer

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 ...

**6**

votes

**3**answers

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 ...

**4**

votes

**3**answers

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
...

**1**

vote

**1**answer

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 ...

**0**

votes

**2**answers

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.