I am trying to create a graph in which the series length is based on the value a user types into a cell.
For instance, if the user type in a "2" then the series length will show the first two values in the series. If the user types in a "4" then the series length will show the first four values in the series. The minimum value would be 1 and the maximum value would be 13.
Thanks in advance.
Any suggestions on how that can be done?