Hi,
So I have attached a file of mine, where I have data that I am comparing between a North site and a South site during the month of August in 2011 and 2012. I have it so check boxes can populate the graph when checked, but I need a way to make it so that my data series can have the same legend description. For instance, if I have one check box checked, it shows the data from North and South in the specified year. The legend will say North for one line and South for the other. When I uncheck that box and check the other one, I want it to have the same North and South description if possible. It's kind of hard to make sense of this in words, but if you look at my excel file you should know what I'm getting at. Any help would be greatly appreciated.
NorthvsSouth.xlsm
Bookmarks