I have the following Excel table, listing the total sales of 3 different cars.
Im trying to create an "interactive" chart that allow the user to select a car, and then, the chart shows a comparision plot between the sales of 2021 and 2022 of the desired car.
For example, this is the comparision plot between 2021 and 2022 for the CAR #1.
Is it possible to create a single chart that allow to select the desired car (though a droplist?) and then it shows me the respective comparision plot?
I have created a droplist and then tried to plot using that droplist without luck:(