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

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

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

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!

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.

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

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

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

Hi, Im using a polynominal equation for a last year thesis but have been having a problem. I have used every polynominal order however none are giving me the correct answer which im using to compare with measured data in order to validate the polynominal equation is working correctly, it is not...

Hi folks, I have a graph that charts percentages by month, Jan - Dec and have a trendline. Now, I am only several months into my year, so I have data in Jan, feb, mar, and apr, and zeros for the remaining months. The formula used for this percentage delivers a zero for the months where data...

This is the first time I have posted here so you will have to bear with me for a moment. I work with shipping containers and I am interested in determining how many slots I can fill on board a vessel with a specific cargo mix. The catch is that while 20' units can fit anywhere, 40' units can...

I have a bar chart (in which I've hidden the bars) and added trendlines for moving averages. There are 3-4 series trendlines depending on the chart. Each chart the trendlines start at the same x-axis, however within that x-axis the lines are slightly off and it is something that has been...

I have a set of data to which I've fit a trendline on my chart. I'm currently using the option to calculate the line with a custom intercept (0), and for the graphing tool this works fine. However, I need to report that slope for some other calculations in my spreadsheet and I would a way to...

I am not having any luck with adding toggling trendlines on or off. Ideally, when the toggle is selected, trendlines would be added and once unselected they would disappear. My chart is modified with slicers, which can cause the trendlines to disappear, therefore, the code would have to...

Hi All. New to the forum, so please be gentle. I have a bubble chart that I have a weighted trendline on. I'm not happy with how the line of best fit gives a misleading representation of the predictability of the data, hence I would like to replace this single line with a band of possible...

Dear everyone, I'm happy to find this forum, this is my first posting. (1) I would like to calculate the slope from multiple sets of data. Since the curves are rather complex, I'd like to be able to easily define the start and end of the "linear region" for which the slopes will be calculated...

I have the following data that I've plotted and trying to forecast when 'Value' reaches 8 <colgroup><col><col></colgroup><tbody> <tbody> Date Value 01 Feb 2015 6.9330 04 Mar 2015 6.9588 04 April 2015 6.9847 04 May 2015 7.0697 04 June 2015 7.1576 </tbody> </tbody> Using a...

Hi Guys.... I'm still trying to get a chart working, in terms of extracting the formula for a trend line. I have now got two distinct problems - the formula isn't being extracted, and the dates along the horizontal axis aren't fully visible. Also, if you access the spreadsheet (I've put it on...

Hello, I'm trying to use a trendline for a one month period (daily on X axis), where I show actual vs forecast data. The trendline is for the actual data, which shows 1 week in the total month. I'm using #N/A to replace zeros, however the trendline is still treating the #N/A as a zero.. Any...

Hello, I have a question that is moderately easy to grasp. I have an chart output in Worksheet 2, with some data in Worksheet 1. I know how to connect the data sets, so that when I add new data, the chart automatically reflects the changes. HOWEVER, I am not able to Auto-Update the...