Creating two charts from the same data source???

13 views
Skip to first unread message

Chris Whyatt

unread,
Apr 30, 2020, 9:40:20 AM4/30/20
to Google Visualization API
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?
Reply all
Reply to author
Forward
0 new messages