wait a min...
You want a chart on excel worksheet together with source data table? Because this is different situation that I had replied to you earlier.
Only way how to prevent hiding lines in chart when hiding rows is to fill that chart via VBA (chart.seriescollection.newseries). Before tahat, you have to clean the lines in chart. Something like this (I coppied this from my wbk, and you have to arrange it to Your conditions):
CLEANING:
GET NEW SERIES NAME AND SOURCE RANGE FROM SHEET (you can put it in a loop or something). 'Ser' and ranges will be assingned according to you selection via button, dropdown etc...:
ADDING LINE TO CHART:
Bookmarks