I have a pile of data (500 rows by 30 columns) on four sheets that I filter and create scatter charts - no problem. I need help with the legend... In the past I've allowed excel to create a full legend then click and delete line by line the duplicates. I tried a text box with all of my text and symbols in a list (about 20 total) then delete unused ones that the filter process has taken out - copy, paste, it works but, I hope someone has a better way. I'd like to create a radio button or check box sheet that would allow me to select which text / symbols I want in the legend and check off the ones that I don't want. Any ideas???