trend

I have a line graph with a trend line and I was wondering is there a somewhat easy way to determine the beginning and end points on the trend line?

Hello, Column A Has My date (over a week) Column B Has my category. (A, B or C) I need to create a Trend Line report for the week to see how the categories appear during the week. Thanks,

Hi guys, Looking for some help on a formula to analyze percentage trend over three years. I have three sets of values 2016, 2017, 2018. and I would like to see the percentage year over year. When i try this formula - =AVERAGE((U2/S2-1),(W2/U2-1)) some work and some don't because i have some...

Hi all, first time poster - long time reader. I am trying to put together a report that shows a bunch of graphs which display the impact of a proposed transaction. i.e. Sales trend - showing the past 12 months (including current month) of sales for "Customer A" on a simple line graph and...

Hello Everyone, I have a scenario wherein I need to know the forecast based on the previous year data. <tbody> Jan.'17 Feb.'17 Mar.'17 Apr.'17 May.'17 Jun.'17 Jul.'17 Aug.'17 Sep.'17 Oct.'17 Nov.'17 Dec.'17 Data 1203 1344 861 1132 1344 1142 900 1706 1552 3002 1358 1367...

I have 17 columns A to R. I want to use the TREND function to enter values in column R, starting at row 3. I have the following code successfully for rows 3 to 39: sub test() dim lastforecastmonth as long lastforecastmonth=cells(rows.count, "A").end(xlup).row range("R").select for I=0 to...

I have a question on charting in Excel. I have a spreadsheet tracking investments over the past few years. I include a “Trend Line” in the chart via a polynomial regression. However, I’m confused on the “order” of the trend line. It allows values 2-6. It appears 2 is the most linear with...

hello all, I am trying to use excel to make polynomial trend (2ª order) of given data. Linest function is returning "#VALUE". xls file in attach: https://ufile.io/6c91i thanks in advance

Hi! I am using a TREND formula for the first time to predict oil price and sales through the end of 2018 (cells using formula in red). I believe I managed to get the TREND formula to work for column B (Price), but do not think it is populating correctly for column C (Net Vol). I will need to...

Hi, Is it possible to have those data points that fall above the trend line one color and the data points that fall below the trend line a different color? Thank you.

I have a sheet with essentially 3 columns of interest and am trying to create a trend graph. First column has a string formatted date (for a week) such as "December 25, 2017", second column has an actual date/time such as "2017-12-28 11:14:09", third column has a value such as "4234234". My...

Line of best fit that isn’t. Have a look at this graph. It shows the latitude and longitude of a paraglider circling whilst drifting over the ground…. (if I’ve clicked the correct buttons, a good quality image of the graph called ‘LineOfworstFit.png’ should be here http://ge.tt/1cadawo2 )...

Hi, Appreciate any help here. I'm looking for a formula that searches a column and runs a count of positive numbers after the appearance of the last zero or negative number in that specific column. Essentially it's looking for a positive trend. If for example the current trend is 2 (2 positive...

I have a scatter plot with 2 data sets plotted which can be updated from a userform. On the form in 2 labels, I update the caption to a projected value from the trend-line equation. When I step through this part of the code, I can see the trend-line equation from the object being pulled...

Hello - I have seen a ton of posts on this topic but have yet to find a solution that actually works. I plotted time series data on a graph and the trend line equation is showing as "y=1E+08x+1E+09" Therefore I tried to get the actual value of the trend line by using this equation against my...

Hello, Please consider helping me with my problem. I have different length rows I would like to analyze with the trend function but I don't know how. For example: <tbody> A B C D E F G H 1 Trend 1 Trend 2 1 2 3 4 5 6 2 4 3.5 4 8 3 3 8 11 2 5 4 6 6 6 5 4.5 4.8 1 7 4 3...

Hi - I am trying to create an if formula to trend a mountain of data I have. Clients travel so many days after booking with us and I am trying to trend this into months. I want 12 days to appear in less than 1month column 36 days to appear in 2 month column 61 days to appear in 3 month column...

Three columns that I want to calculate the trend for. Columns are always changing in height with a max of 100. Columns are a1:a100, b1:b100 and c1:c100. Looks like I need to use offset but I am not too familiar with that. What is the trend/offset formula? TIA

I am looking to create a worksheet where I can track trends within a row. There are about 20 different optional trends and each user can pick up to 5 trends per row. However, I want to be able to analyse these trends as a whole in a pivot table (rather than separated as trend 1, trend 2 etc). It...

Does anyone know how to create a small monthly graph trend of expenses similar to ones on some of the Financial KPI scorecard? Need some help in adding some graphical information to my monthly financial expense reports. Thanks