Display weeks and hours

Your current named range approach only determines the number of items to use but starts selecting that number from the top of the list. Which means the zero values as still included.

You need to create an alternative set of data with the zero values removed.