trends

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

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

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

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

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 :)

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

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

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

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