Assistance with trend

Trend.xlsx

Is this what you want?

Sorry, no. And after re-reading my initial question, I didn't really spell it out. I want to show, using the FY2012 and FY2011 data that the 2012 volumes will continue to decline so in essence, I want to show a nominal decline for each projected month going forward until April 2012 and I would like to be able to show it into the new FY2013. I hope this makes more sense.

Can't you just add a trend line or predicted results to the graph?

You have make the predicted results have a dotted line carrying on down if you want.

I added a linear trend line graph in my analysis but I'm trying to prove a point and my big wigs are wanting to see some physical numbers. I'll add a sample of what I presented to them but they want to see what impact this linear decline will look like to our FY2013 budgets.

I added additional data on sheet 3. My hope is to trend out the trend of decline through the next fiscal year. I dunno, it might not even be possible within reliability.

You can use a polynomial trend line or as I said before I would make up data for FY2013 and just make it a dotted line to show it is predicted. At the moment you've placed 2011 and 2012 together. To get a graph progressing forwards flatten out the data. So something like Jan - 11 ..... Oct 11 .... Jan 12.... Sept 12 ... Jan 13 along the x axis.


Trend.xlsx

I love the polynomial trend line, but I still need to provide them with projected volumes for the preceding months of the FY2013 budgets. Even though we physically had a surplus volume over the FY2011 volumes, we (we being me) know that those numbers were inflated and I'm trying to justify reducing our volume over the FY2012 actual volumes by a minimum of 10% but the uppers think I need to prove my point. I tried using the Linear decline, but they are still not seeing it so I'm trying to use some form of formula that will show me a trend, by month, of what we can expect for volumes. If my thesis is correct, I pretty sure, using a trend, I'll see a substantial volume reduction over this current fiscal year, but I'm having trouble getting to that point.

Sorry for the bump, just wondering if any others and/or darknation144 (and thanks for your assistance regardless) might have some additional insight per chance?