Excel MAX function and graphing expertise needed

[H. Craig Miller]

What------not posting the solution?

Though not the only solution, the most graceful solution to the MAX function issue (the one utilized) was suggested by Ezra Christensen on the OpenRocket Facebook forum, the use of the OFFSET function:

=IF($A$6="","Import Flight Data",MAX(OFFSET($B$6,0,0,$M$5,1)))

 

[H. Craig Miller]

What------not posting the solution?

The auto-sizing of the graph was achieved by way of the way Excel processes the data points, ignoring empty cells. Where the maximum allowable number of data sets is known, 3000, the graph data set includes the full 3000 data sets:

='Sheet 1 - Table 1 (Forward)'!$A$6:$A$3005,'Sheet 1 - Table 1 (Forward)'!$K$6:$K$3005

And that portion of the data set that is not used was made blank, rather than 0:

=IF('Paste Flight Data Here'!A1>0,'Paste Flight Data Here'!A1,"")

 

[waltr]

What------not posting the solution?