I have a workbook I'm working on and I have multiple charts that are all linked to different dynamic named ranges. The problem I am having is that the number of series in the graph will change and I cannot figure out how add/remove series without having to change the chart. The orange line on the attached spreadsheet is what I am talking about.

If I delete all the info in row 12 on the "Data" sheet I want the "E" series to disappear on my graph, but I for the life of me haven't been able to figure it out. I've tried using one named reange to graph all the data but that doesn't work either... Please Help! I am using 2007.

Dynamic Chart Experiment.xlsx