# trendline

1. ### How to Convert an Exponential Trendline Equation to a Formula

My data is in 2 columns. Column A is my Y axis, Column B is my X axis. I have maybe 30 rows of data, and I created a line with markers graph using that data. Then I right clicked on the data line to have Excel create a Trendline using Exponential. I then clicked the option to show the...
2. ### How to get two Trendlines to start and stop at two different intervals on a chart

All; I researched and trialed different options on this for awhile, I am not a charting expert but what I'm trying to do is chart two separate trendlines for two separate time intervals but only show (and have the trendline effected by the data of that interval. Below is the data and where I...
3. ### Trendline formula

I added a trendline to a graph. How does excel figure out the trend?
4. ### Trendline equation in chart - need "m" and "b" linked to cell that updates dynamically with chart

I've read a few dozen posts on linking trendlines to cells, but none of them seem to offer a solution to my problem so far. The trendline equation on the chart automatically updates to reflect what data in a table is visible (not filtered out). All of the formula equations I've seen use the...
5. ### Problem with VBA Code - Chart

Hi Everybody, I am having a problem with Excel VBA codes. The code that i am trying to do, makes a prediction with the chart. But, i don't know why, every time that i run the code, excel just start not to responding and crash it all. (I am from Brazil, so, sorry for any english mistake); It...
6. ### Help with Trendline

Hi all Tearing my heair out all afternoon with this ..... I have a table of data which I am using a chart and then I want to use the trendline equation from the chart (polynomial formula) - in other cells. I am using the INDEX / LINEST function .... but the function is giving me different...
7. ### Add Series Line to portion of data set

I want to add series lines to an XY scatter plot but control which data points are connected (and not connect the whole series). I haven't found a way to do this, I'm wondering if anyone has any tricks. I know I can create separate series to resolve this, but the data categories repeat...
8. ### exponential trendline

Hi, I want to add an exponential trendline to my graph - but the option is shaded out. I'm in excel 2016 - does anyone know what the issue could be? Thanks
9. ### How to find optimal data range to fit exponential trendline?

Hi, Excel pros! I am looking through various datasets of Google Trends to find the most optimal data range that fits an exponential trend line. Do you know of an automated way to identify the most fitting data range in a graph (i.e. with the trend line R2 value closest to 1)? Currently, I...
10. ### Trendline

Hi I want to know based on what excel draw the trendline? Does excel take the average of values and draw the Trendlne? I have a chart look like "V" letter but upside down. When I right click --> trendline, excel will draw a line in the middle. It seems to me excel took the average values and...
11. ### Calculation of Slope & Intecept of Logarithmic Trendline

Hi, I have produced an x-y scatter chart from the following two columns of data. <tbody> åkDt hours Comp. Strength (N/mm²) </tbody> <tbody> 11.36 6.2 16.31 12.9 25.18 18.4 29.36 24.4 38.21 30.5 88.41 41.4 349.29 63.6 </tbody> The X scale is formatted to Logarithmic Base 10...
12. ### excel chart with trendline doesn't show the correct function

I have a file with only four values for x & y when I make a chart and insert the trendline form +-x³ +- x²+- x +- cte the backsolving of the trendline for the values of x doesn't result in the expected value for y any help is greatly appreciated can give the file with the chart if needed...
13. ### Find the maximum of a polynomial trendline

I would like a formula that automatically figures out what the maximum of poynomial trendline will be no matter what numbers i plug in there. I've seen a few explanations but they are all way above my head. My X axis is A1:A4. Y axis B1:B4 X Axis Y Axis <colgroup><col...
14. ### Trendline Equations - Can't Get *Future* Values from 3rd Order Polynomial

Hi All, For several years now I've used the formulas from this page: http://spreadsheetpage.com/index.php/tip/chart_trendline_formulas/ ..to great success with easier equations like Linear & Power. However I've now tried 3rd order polynomial and I've run into a distinct problem. I can get...
15. ### Get graph and trendline to not display non-numerical values as zero

I have a graph that draws information from two columns in a simple table. The information is drawn from cells that contains formulas, for example: =IF(COUNTA(F4:H4)>0,LN(E4),"-"). I've tried replacing the "-" with "", "x", and nothing, but the graph always picks up the non-numerical value and...
16. ### Linear trendline to forecast data

I have a simple chart showing calls by day average. Year 1990=100 1995=200 2010=400 2014=515 I want to create a simple line graph and add a trendline showing what calls might be in 2025. Help please. I think I'm over thinking this!
17. ### Calculate Trendline With Dates in X Axis

I need to know how to calculate the slope and intercept of a trendline for the following data: <tbody> 3/20/2017 62.7% 4/10/2017 58.5% 4/17/2017 62.2% 5/1/2017 60.5% 5/8/2017 60.9% 5/15/2017 55.6% 5/29/2017 58.0% </tbody><colgroup><col><col></colgroup> Any help is appreciated.
18. ### Code Stopped Working

My code referring to the colour of the trendline has stopped working. It was previously working fine, but now threndline is white. Sub AddDeals() ' ' AddDeals Macro Dim Wkb As Excel.Workbook Dim ws As Sheets Set Wkb = ThisWorkbook Set ws = ThisWorkbook.Worksheets ws_count =...
19. ### Trend Line X Axis longitude problem

Hello Everyone, Many thanks in advance. I have an issue where by a data set on a XY scatter graph is joined with Linear Trend line. It is used to show the routes a ship takes and the scatter graph has a map as a back drop, x axis is longitude and y is latitude. The longitude (x axis) starts...
20. ### find two curve intersection realtime!

Hello all, hope the best. I have two set arrays that I want to find intersection point of them. One way is to fit a trendline and find the equation for each. then solve the equations and find the intersection. Problem is that everytime that any of those arrays changed a new trendline need to be...