Creating dynamic charts in Microsoft Excel - Part 2

Excel’s FV function calculates the future value of an investment assuming a constant interest rate and periodic, constant payments.
Related videos:
Creating Dynamic Charts - Part 1: kzbin.info/www/bejne/pqHcqIKwmJeLiMU
Creating Basic Charts: kzbin.info/www/bejne/h2HQY2CfrsRplc0
This video was created by Optimum - the IT Training Consultancy.
For more information on our Microsoft Office training courses provided in central London, UK - please click here: www.optimum.co.uk/microsoft-office/

[@Waineo]

Thanks Mark. For people's copy and paste ease: =OFFSET($A$1,COUNTA($A:$A)-$D$2,0,$D$2,1)

[@zenithpersonaltraining5714]

Great video. How would you change the formula if you wanted to work from the first year to forwards rather than the last year back?

[@OptimumERP]

Hi thanks - Thanks for the comment. Rather than attempting something potentially complex, why not simply change the order of your data? Descend the years - go from newest to oldest - with everything else remaining the same. Hope that helps.