I created a 5-series dynamic chart using 5 different offset formulas (one for each series in the graph). The series name / data is retrieve from 5 cells in a table. When I try to only display data for 4 returns , the 5th return is still accounted for in the legend - I'm assuming this is because an offset formula is linked to the cell from which the data line is drawn. Is there a way to fix this, so that if I choose to only display four rows , only those rows are graphed? I dont want to remove the formula from the 5th cell because there are times when I will want to compare all 5 series.