Excel 2010 Trendline With Data labels or number on forward forecast trendline

My data set is very simple... Its 7 months along the top and 7 amounts below. I create a basic line chart based on this data, click on the line and click to add a trendline. I select a logarithmic trendline and forecast it forward for 5 periods. But for the life of me I can't figure out how to get the bloody amounts excel is forecasting on the line. I need the actual numbers its forecasting. I've attached a spreadsheet. I don't care where the numbers show up (On the chart, in a table below the chart, completely outside the chart using formulas... don't care where, just need the actual numbers!!!) In a previous version of Excel (I think it was 2008) this was very simple and easy to do... I just had excel include the table with chart and bam, the numbers were there, but 2010 this appears to be problem.

It took a bit for me to figure out how to get the formula to work right, but I got it. Thanks

Hi,

I'm having some trouble with converting the actual formula that Excel gave me- any chance you can help??

y = 6E+07ln(x) - 1E+09

thanks

You need to convert the scientific notation by using x 10 to the power, so for the first part you need to type in =6*10^7 (which is equivalent to 6E+07) and similarly for the other =-1*10^9. You can confirm that you get it right by formatting the cell that you input this into as "scientific" which then should get you back to the 6E+07.