Dear Experts -
I am trying to graph data shown on the "Graphs" tab. The data shown under each loan is driven by the start year put on the "Projections" tab which also drives other parts of the model. Based on the year inserted the graph table will pull data from the outstanding debt tab. Depending on the year chosen some of the loans may not have any data to show for the range displayed. So I have two things I would like to address here. (1) If there is no data to display is there a way to dynamically remove the series when the loan does not have any data to show but alternatvely if a range is selected were the loan does have data it is added to the graph, (2) how can a dynamicaly size the graph so that the graph on goes out as long as the last maturity of the loan? I have attached the filing of what I am working with to hopefully shed some light on what I am asking for.
Thanks in advance for your help!