Hey there,
For the last few days I’ve been working on putting together an XY scatter plot chart that populates based on what check boxes I have checked. I’ve been able to accomplish this in little time but have been stuck trying to remove the blank series animation lines that remain in the legend when a check box is not clicked. I have about 40 different data curves and only need to compare 5 or 6 at a time. I would like the legend to shrink and only show what’s checked with no gaps/ blank lines remaining. I’ve played with a few different VBA scripts I found online but no success.
Any help would greatly be appreciated!
The two photos were taken at different times -hence the difference in clicked fields
Bookmarks