Variable Graph Limits

JetEscamilla

Board Regular
Joined
Apr 17, 2006
Messages
89
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?
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,118,877
Messages
5,574,770
Members
412,617
Latest member
mlharris
Top