I have been using slicers in order to filter the data that I have displayed on a scatter chart. I was wondering if it was possible that when selecting multiple selections in the slicer, the different selections would show up on the scatter chart in different colours/markers.
Or is there a different way to easily filter data? I cannot use pivot charts as I need the data in a scatter graph and I cannot put each selection as a different series as there is more than what is allowed on one graph.
Thanks!
Or is there a different way to easily filter data? I cannot use pivot charts as I need the data in a scatter graph and I cannot put each selection as a different series as there is more than what is allowed on one graph.
Thanks!