trends

  1. T

    Data trend without a graph

    I am attempting to trend data without using a graph. The data would look something like this: Week Revenue 1 $90,934.15 2 $143,314.75 3 $134,522.00 4 $202,343.00 5 $177,218.00 6 $132,985.75 7 $113,291.00 8 $62,821.00 9 $151,983.00 10 $161,214.80 11 $142,278.45 12...
  2. R

    How to track when project spending has slowed for 2 months in a row?

    Hello, I'm wanting to create an indicator that shows me when a project has overspent for multiple months or under spent by multiple months. I want to do this for over 50 projects. I have monthly spending by project. I'm considering using outlier formulas to show me when spending is abnormal...
    • Rcaaa
    • Thread
    • outliers spending tracking changes tracking spending trends
    • Replies: 1
    • Forum: Excel Questions
  3. M

    Incrementing worksheet number in a formula ?

    I have data in workbooks and on worksheets and I would like to show some of it on another workbook. I understand how to get the values from the cell I want but is there a way to copy and paste the formula so that it changes incrementally. I have a workbook called Trends, with numbered...
  4. 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...
  5. T

    VBA to get Google trends automatically.

    Hi all, I've been searching for a way to use VBA code to get Google Trends data automatically on to a spreadsheet. Does anyone know how to do this? I can't seem to find a way at all. Thanks :)
  6. I

    Multiple Budgets over a range of months and years, with monthly cost/estimate showing by month for each project

    I have hundreds of rows of data. Each row is a project and cost with start date and end date. Some projects are old and complete, others have started and are ongoing and some have not even started. Using the full range of dates, I want to show the cost of each project by month. I've added the...
  7. R

    Advice on using .NET programming to create Custom Excel reports tied to SQL Server

    This is more of a career question for general advice on Excel Object Model Programming. Not that I have been looking for it, I have not seen .NET applications that utilize Excel Object Model Programming. Is this a niche' market? Would it be something worth pursuing? Does Mr Excel have training...
  8. M

    Trend (?) tutorial

    Can someone point me to a good tutorial? I have very simple data - On certain dates, I measure how much hard drive space I am taking up. I would like to project when, based upon date and the rate I will be out of space. I think that is Trend, but could it be "Linear"?? <TABLE...
  9. C

    Graphs, trends and series data Help needed

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p>:confused: </o:p> Hi All,<o:p></o:p> <o:p></o:p> I currently have a graph based on 7 data sets, 5 are similar. 2 are % trends. I have a column graph, with values on top of each other, in weekly...

This Week's Hot Topics

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
Top