Hi,
In a scatter plot, if I click on an element, is there a way to not only select that one element, but also all the elements that are in its neighborhood (circular filter)?
Thanks
2 answers
Yes, this is relatively simple. See the attached example, using the Superstore sample database, I created a group containing sub-categories Supplies and Fasteners. For the scatter plot, I put profit on columns and discount on rows. I then put Order ID on detail to distinguish the points, and also put the sub-category (group) on detail.
Then, it was just a matter of creating a worksheet highlight action, specifying the sub-category (group) as the Target Highlighting.
I hope that helps.
