How do you visualize overlapping data?
Rainbow boxes are a new technique for overlapping set visualization, inspired by the matrix approaches. It aims at visualizing relatively small datasets in detail and in particular knowledge expressed as overlapping sets.
How to do overlap analysis in Excel?
Open the workspace that contains the data sets that you want to identify overlaps for, select one or more data sets, and click Run relationship analysis. Select Overlap analysis. Then, click Analyze. Note: You can run a key relationship analysis at the same time that you run an overlap analysis.