Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2013, 01:24 AM
bmoody bmoody is offline Creating a graph for Future Value function (FV function) Windows 7 64bit Creating a graph for Future Value function (FV function) Office 2013
Novice
Creating a graph for Future Value function (FV function)
 
Join Date: Nov 2013
Posts: 2
bmoody is on a distinguished road
Default Creating a graph for Future Value function (FV function)

Hello!



I have tried to find a solution for this for a while now. I used the search function but did not find the solution from this forum either.

I am pretty novice with Excel and I am using Excel 2013. I am using FV function to find out the future value of a monthly investment with a fixed interest rate.


FV(rate,nper,pmt,[pv],[type])

I have a data sheet where you just fill in the interest rate, the monthly investment, the possible initial investment and the investment time in years. The formula gives out the future value of the investments. But I would also like to have a graph that always changes according to input values. So that the value of the investment would be on y-axis and time in years would be on x-axis.

Is there an easy way to do this? Is there a command that would give the output of the function? So I would make the graph of the output. Or is there a direct method for creating a graph straight from the function?
Reply With Quote
  #2  
Old 11-06-2013, 08:37 AM
BobBridges's Avatar
BobBridges BobBridges is offline Creating a graph for Future Value function (FV function) Windows 7 64bit Creating a graph for Future Value function (FV function) Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Here's a general idea of how I'd do it. I don't work with graphs much, so you'll have little difficulty making it a lot prettier.
Attached Files
File Type: xlsx x.xlsx (11.9 KB, 75 views)
Reply With Quote
  #3  
Old 11-06-2013, 10:52 AM
bmoody bmoody is offline Creating a graph for Future Value function (FV function) Windows 7 64bit Creating a graph for Future Value function (FV function) Office 2013
Novice
Creating a graph for Future Value function (FV function)
 
Join Date: Nov 2013
Posts: 2
bmoody is on a distinguished road
Default

Thank you very much. I think that this solves my problem.
Reply With Quote
Reply

Tags
future value, fv

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a graph for Future Value function (FV function) IF function msheyworth Excel 2 03-28-2013 02:15 AM
Creating a graph for Future Value function (FV function) Sum Function teza2k06 Excel 3 02-06-2013 08:29 AM
Creating a graph for Future Value function (FV function) how to use now() function gsrikanth Excel 1 01-07-2012 01:18 AM
if function help jim831 Excel 2 10-29-2010 07:06 PM
Creating a graph for Future Value function (FV function) Need help on what function to use??? Primeraman Excel 1 06-13-2006 10:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft