Dynamic chart with dynamic input

Hi Excel Forum,

I am trying to make a dynamic chart for a dashboard like a graph.

Problem is that the chart needs to exclude #N/A from the chart
the input for the chart is in one tab (Data IN)
and fetched to another sheet (Data Out) where the chart is allocated.

The problem is the inputs are everchanging and need to resize (Gap out #N/A and 0) every time a new Task is fed into the (Data Out) sheet.

- My goal is to exclude and don't have any gaps every time a #N/A or zero is located in the (Data Out) sheet.

Thanks

Lasse

Hi both,

Thank you very much for your help.
I think my question could be clearer. Both of you tweaks work, however, I am still generating 0 or #N/A if NA() is used
The problem is I have multiple lists (named and used as arrays) with data that needs to be used in the chart separately.
see fx. list one marked with red and list three marked with black.
under the dropdown, I have marked twenty cells, room enough for even the longest of the lists.
however, when inserting and using list one in the dropdown it will result in 11 zeroes or not empty cell which then will result in a gap at the end of the chart.

That's the dynamic input part of the question.
I don't know if this is possible or if I am stretching the capabilities of XL.

Thanks,

Lasse

Forgot the image



Thanks,

Lasse