Display weeks and hours

Hello!
I want to see on the chart weeks filled with hours.
Attached example:
See weeks: 1, 2, 3, 10, 12, 15, 19, 20, 21....

Chart_example.xlsx

sorry, im not understanding what you are trying to achieve? ould you explain in a bit more detail please?

does this one work?

@ cascao ... i am not getting what exactly u need .. can u please explain a bit

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.

Andy, one more question:
If the previous week, the hours are greater than 0. The next week, even if hours = 0, will appears in the chart..
Example:
WEEK 9 - 22:00:00 - show
WEEK 10 - 0:00:00 - show
WEEK 11 - 0:00:00 - hide
WEEK 12 - 12:00:00 - show
WEEK 13 - 18:00:00 - show
...

Got it. I added OFFSET:
=SMALL(IF($C$2:$C$22>0;$A$2:$A$22;IF(OFFSET($C$2:$C$22;-1;0)>0;$A$2:$A$22;ROWS($A$1:$A$22)));ROW($A$1:$A$21))