Interactive/dynamic chart: Multiple selection criteria for user

[jayexcel1]

Hi,

I have sales data of two products Product A and Product B which are sold through 2 different channel partners Channel A and Channel B for last 3 years.
I want to make a dynamic/interactive chart where :
the user can select:

1. either Product A or Product B
   
2. either Channel A or Channel B or Total
   
3. year ( 2013 or 2014); based on this selection either (2013 & 2014) data or (2014 & 2015) gets into the chart; similarly respective %variance data should also become visible in the chart.

%Variance should be plotted on a secondary axis always.

Attached is the copy of sample data for reference.

jay.

 

[Asheesh]

Hi Jay....

Are you OK if the layout of the base data is changed..

 

[Asheesh]

Jay - Check the attached and let me know if it makes sense

 

[jayexcel1]

Thanks Asheesh for your time and reply.
Couple of things I would request you to incorporate:
1. Volume data of selected year and previous year (if available) should also be shown in the chart preferably Column chart.
2. A tick box for Total volume in addition to Channel A and Channel B; so that Total volume comparison could also be made.

Would be really helpful if it is possible for you to accommodate a small write-up on how I can replicate this on a completely new worksheet with actual data.

jay

 

[Asheesh]

Hi Jay..I have made the changes as suggested...

Let me know if it is not what you are after

 

[jayexcel1]

Thanks Asheesh. I will manage the rest .

Just a quick query though: Is it possible to have the chart title change dynamically based on the user selection. For e.g.
If I select Product A, Channel B and Year 2015, then chart should show title as
2015 - Product A Sales through Channel B.

jay

 

[Asheesh]

Jay - see the attached