JetEscamilla
Board Regular
- Joined
- Apr 17, 2006
- Messages
- 91
- Office Version
- 2016
- Platform
- Windows
I am sure this is a simple question.
I have a spreadsheet that displays amount invested and net worth vs time (months). I have it set up so that the user of the spreadsheet can input the length of time they can project what their rate of return for "x" amount of months would be. So I have 360 rows (equivalent to 30 years) of data. The user can input something like 120 months (10 years) and see how much he has invested to date and what his expected return would be.
I would like a graph that would vary the x-axis to the limits of 0 to 12 months (for the example) and would be able to change to whatever month that gets specified. Can this be done?
I have a spreadsheet that displays amount invested and net worth vs time (months). I have it set up so that the user of the spreadsheet can input the length of time they can project what their rate of return for "x" amount of months would be. So I have 360 rows (equivalent to 30 years) of data. The user can input something like 120 months (10 years) and see how much he has invested to date and what his expected return would be.
I would like a graph that would vary the x-axis to the limits of 0 to 12 months (for the example) and would be able to change to whatever month that gets specified. Can this be done?