Dynamically sorting Charts But by using outside variables

[Newfs_R_Sublime]

I have sorted data that I use to compose several charts. However, I need to be able to run some of those charts based on when the value in G becomes 0 (I can make it #/N/A to make it easier). For example:

The total data is between a2:k95. G became 0 on row 80.

I need to dynamically change my chart parameters so I can run charts between A2:K95, A2:K79, and A80:K95.

The data is not always the same length. So 95 was just the example for today. tomorrow it could be 86 and G become 0 on 81.

An indirect feature within the charts would have been fine, but that doesn't work-at least the way I tried.

Thank you.

Rick

 

[Newfs_R_Sublime]

I'm sorry , I created an area where the values of the data length and row where G became 0 can be entered.

 

[Newfs_R_Sublime]

Can this be done?