Specific row removed/hide from chart

Hi all,

I am trying to erease specific data from a chart but can't find the solution for this.

In the attached excel file you can find the chart (sheet2), I want that IF a row with #VALUE! is displayed, the data removes/hides from the chart as it led to a lot of confusion. I am limited to change the reference in Column A at Sheet2 because this is linked with the table in sheet1 and this again is linked with a Userform.

Thanks in advance.

Turn on the Filter for the table in Sheet2, then unselect "#VALUE!" from Part column.

Originally Posted by josephteh

Turn on the Filter for the table in Sheet2, then unselect "#VALUE!" from Part column.

This works Josephteh, thank you.