Interactive chart with multiple combination

[pankaj@2610]

Hello,
I have a excel table. I wish to have a interactive chart with multiple combobox on single chart.
Were the user select the main filter company code
Once company code is selected the user need to see the chart in different forms:
Cropwise usage
Product wise
Year wise
Month wise
I have tried to develop some chat but unable to get in single chart. It will be helpful if I receive the some guidance in this regard.
The attachment is as follows:

 

[chirayu]

There's a lot of discrepancy in the data set... Please fix

 

[pankaj@2610]

Hey Thanks a lot for your time, but I dont see any discrepancy in the data. Can you please be more specify were ou found the discrepancy in data.

 

[SirJB7]

@chirayu
Hi!
If you're referring to worksheet Usage cells N4, N6 and O2:O6, that's not any obstacle at all to proceed with the rest of of the table (67 rows) as you can easily place any correct values in those 7 cells.
Or am I wrong and you're talking about other thing that I didn't see?
Regards!

 

[pankaj@2610]

Hello,
I have fixed up some of the things, please check the data in Usage sheet. The idea here is, the user should see the chart with different combobox. So when he select the company he should be able to see data from different points like polymer usage month wise; crop wise polymer usage, yearly usage month wise.
Attaching corrected data

 

[chirayu]

@SirJB7

I was in general talking about the entire usage sheet the month column had missing months - I know how it was calculated by lookin at the data - I just didn't edit it to be sure

 

[pankaj@2610]

Hello,

 

[pankaj@2610]

Hello,
can I expect some help on this.

 

[NARAYANK991]

Hi Pankaj ,

What you are looking for is quite some amount of work ; if you expect that this will be done in a hurry , I think you are in for some disappointment.

In case you do not want the entire application done for you , please explain exactly what kind of help you are looking for , and hopefully , someone will step up.

Narayan

 

[chirayu]

Is this what u want?

 

[pankaj@2610]

Thanks a lot for your support, What I am looking is when user select year and specific company the data should be seen only of specific company of that year.
Attaching herewith attachment.

 

[chirayu]

Since my charts are pivot charts - its simple - drag the year and month up into the report filter section and use that as your year month filter

 

[pankaj@2610]

Write but I would like to have the control on chart itself, so we need to syncronized the two combo box here year & Company. I request your help on syncronizing this combobox on chart

 

[pankaj@2610]

The attahment is as follows