I am building a report that shows change in school enrollment throughout a registration period using two line graphs: one that shows a full registration period (150 days), and another that focuses on a 4 week period centered on the current day using a simple filter. In both graphs, I am grouping the data by semester, so that users can compare enrollment trends for different semesters. I am also allowing users the option to select which terms to compare by linking a (control) list of 30 semesters to both line graphs. They may want to compare up to 5 semesters or so.
Unfortunately, I am finding that the default colors assigned to each semester differs between the two graphs, so that it will be confusing to the user which is semester is which. I realize that I could use a display rule to force each term to a specific color, but there are 30 semesters, so this really isn't a viable option. Even if I did use display rules, the many of the 30 colors will be very similar, so some combinations of semesters will not have sufficiently distinguishing colors.
Does anybody know what is going on here or how to fix this problem? I have tried both a forked interaction, in which the semester control points to both graphs, and a path interaction, in which the larger-scoped graph points to the smaller-scoped graph. Both show the same problem.
Thanks in advance.
