trend

  1. P

    Extrapolating a future value using two values

    <tbody> Day Price 1 1.0 2 3 5.0 4 5 10.0 </tbody> Hi I'm trying to calculate a future value based on a trend line calculated off two values. I've tried searching example/tutorials and can only find where the data is fully populated. I'd like to use something like the...
  2. D

    Trendline data points

    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?
  3. L

    Need to create a Trend Line report for a specific week

    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,
  4. R

    Trend Formula

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

    Proposed change to trend line

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

    Data Forecast

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

    VBA Trend function with variable rows

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

    Charting with Trend Line

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

    Linest not working - Polynomial Trend

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

    Omit column from Trend formula

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

    Scatterplot chart question

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

    Trending values over time

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

    Line of worst fit !

    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 )...
  14. D

    Conditional running total

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

    Pulling Trendline DataLabels to String Sporadically Working

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

    Linear Trend equation not working for actual values

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

    Trend function different length rows

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

    If Formula - Greater than 30 but less than 60

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

    Trend offset combo

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

    Tracking Multiple Trends in a Worksheet

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top