Hello,, I came across this x-y scatter graph and was quite fascinated by how it changes visuals based on the slicer selection. By default it's showing all the data points(1st image) but as we change the slicers(2nd & 3rd image) only the relevant data gets highlighted and the rest gets graded out.
Image 1
Image 2
Image 3
No macros or VBA has been used here. It is created using only formula's and function.
FYI, when I click on the coloured data points(without any slicer selection) it point me in the data range which is fetch using the formula-
=iF( H41=0,
NAO),
INDEX(_01_data[date]
SEQUENCE(H41)))
And upon clicking on the coloured data points(with items selected on slicer) it point me in the data range which is fetch using the formula-
= LET( array,
CHOOSE( (1,2), K11#, L1 1# ),
years,
ROUNDDOWN( K11#, 0),
filteredyears,
FILTER( array,
ISNUMBER( XMATCH( years, G49:G59 ))
hours,
ROUNDUP( INDEX( filteredyears,,2), 0),
filteredhours,
FILTER( filteredyears
ISNUMBER( XMATCH( hours, 149:1721
INDEX( filteredhours,, 1))
Would like to know how to highlight data in such a way as I really found it to be visually appealing. Is it possible only by using such LET or INDEX function.
Will be helpful if someone is aware about it and how can I implement the same for future as well.