Dillina
Member
Hello Guys and Happy Easter!! 
Sorry if the question is stupid but I'm only now beginning to study Tables Pivot, Slicers and Timelines.
For many months I have not found the way (and I do not know if it's possible) to insert a Slicer into a dynamic chart (combined) like the one I posted here.
I have two tables (no Pivot) and I think that I have to create a pivot table to create the Slicer, but I do not know how to organize the data well because I see a Slicer like the one I drew in the file. I will also need a Timeline later.
I would like to click on "Apples" and only the apple line appears in the graph. Click on "Pears", only the pear line appears ... etc. etc.
(Not changing the category of the Commercial name (Y))
If I have not been clear .... maybe it's because I ask for something that can not be done .... but I've seen a few things that can not be done with Excel!
I hope in your help
Sorry if the question is stupid but I'm only now beginning to study Tables Pivot, Slicers and Timelines.
For many months I have not found the way (and I do not know if it's possible) to insert a Slicer into a dynamic chart (combined) like the one I posted here.
I have two tables (no Pivot) and I think that I have to create a pivot table to create the Slicer, but I do not know how to organize the data well because I see a Slicer like the one I drew in the file. I will also need a Timeline later.
I would like to click on "Apples" and only the apple line appears in the graph. Click on "Pears", only the pear line appears ... etc. etc.
(Not changing the category of the Commercial name (Y))
If I have not been clear .... maybe it's because I ask for something that can not be done .... but I've seen a few things that can not be done with Excel!
I hope in your help