HELP !!! HOW TO MAKE A LINE GRAPH IN EXCEL WITH START DATE AND END DATE CHANGING THE GRAPH WITH RESPECT TO VALUES

[DavidKele]

Something like this, with the attached values

The values are too long and I need to see graph showing at maximum 15 values at a time and be able to switch preferred dates.

Thanks in advance.

 

[offthelip]

The way I would do this is to use a couple of helper columns for example columns Z and AA . I put the value 1 into Z1 then in Z2 I put :

=INDEX(W2:W46,$Z$1)

then copy this to AA2 and then copy both down to row 16. Then plot a graph using Z2 to AA16.
If youy now change the value in Z1 to Z3 you can see that the values move along starting at Row 4. So you just change the vlaue in Z1 to get whichever bit of hte graph you want