So I currently have a line graph with 48 different lines, comparing 48 different series of data. The series are generated by changing three variables: One with two possible values, one with 4 possible values, and one with 6 possible values.
One column contains each series, and 3 rows of headings indicate the various combinations of of the 3 different input variables. (Sorry that I can't post a picture, but I just jumped over to this site from stack overflow, and don't yet have the reputation.)
What I'd like to do is create a line graph that I can then filter on the fly for various combinations of the input variables. (Pivot chart style stuff) The problem is that the data isn't, and can't be put into (I don't think) a format that is amenable to excel's pivot functionality. I'm wondering if there's any easy way to do this, without having to break out the VBA editor.