I've using Google sheets to update some data, where I have two columns of data and a third column which is a label (for example label 1 = apples, label 2 = oranges)
when I'm creating a chart, and then add a slicer to filter the data for all rows with "apple" as a label it works fine. However, if I want to create a duplicate chart but filtering by "oranges" the second filter is somehow linked to both charts and therefore updates both charts with the new filter.
Is there is a way to unlink the filtering, so I can have two versions of the data in two separate charts?