I have data that is populated in a line chart from AN6 (miss AN7) then from AN8:AN94.

I use AN8:AN94 in my line chart. However, I want my line chart to be dynamic and use all data that is within column AN? How do I go about doing this and including AN6 as the start point, missing out AN7 aswell?