The trendlines tag has no usage guidance.

**5**

votes

**3**answers

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

**3**

votes

**3**answers

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

**3**

votes

**1**answer

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

**2**

votes

**1**answer

713 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

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

**1**

vote

**3**answers

576 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?

**1**

vote

**1**answer

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

**1**

vote

**1**answer

3k 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

667 views

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

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

**1**

vote

**1**answer

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

**1**

vote

**1**answer

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

**0**

votes

**2**answers

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

**0**

votes

**1**answer

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

**0**

votes

**0**answers

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