interactive chart

[arnab0711]

Hi,
I have this excel workbook which has 5 sheets KOL,WB,Assam,Final,Graph
the final sheet should contain the sum of all sheets
The graph sheet has a graph based on final sheet.
Now I want to create a combox form control and at change of each item in combo box the data will
change accordingly.For example if I select PDH Antenna then it will show all the data partaning to
PDH antenna of all 12 sheets.

[Bob Phillips]

Where do those numbers on Final come from?

[arnab0711]

Actually the numbers should be the sum of all sheets but here I have taken arbitrary numbers just to show the charts.

[Bob Phillips]

Try this

[arnab0711]

Hi,Thanks for the solution,but if I don't want the sum only a particular number what will be the formula in final sheet

[Bob Phillips]

What particular number do you mean?

[arnab0711]

for example if I select PDH antenna in the combo box we will see the D4 figure of
Assam in Final sheet as "44" which is the sum of 4 months,but my requirement is for one month,because I want to add another spinner button to the chart that will traverse the months.

[Bob Phillips]

First thing you need to do is remove those merged date cells and put the date in each row, then change the formula to SUMIFS with the extra condition.

[arnab0711]

Hi,
I have a little problem,if I remove the sumproduct its showing #value,can you help me with the problem.

[Bob Phillips]

Why are you removing it?

[arnab0711]

to get figure for one month only.not the sum of all months.

[Bob Phillips]

Read what I said in post #8.

[arnab0711]

I have removed the merged cells,but I am little confused about the extra conditions in sumifs

[Bob Phillips]

Post the revised workbook, i.e. no merged cells, and I willdo it for you.

[arnab0711]

Hi,
Pl find the spreadsheet with unmarged cells

[Bob Phillips]

The formulae are correct here, but your dates are bad. For some reason you entered the 1st for Jan, but the 2nd for Feb, Mar,.... You need to change them all to the 1st.

[arnab0711]

Thanks its working,can you also help me with the check boxes in the graph sheet,my objective is if I select any particular check box on that details(stack)will be shown,or else it won't be shown

[Bob Phillips]

Maybe this is okay

[arnab0711]

Hi,
In certain places the figures are not coming,for example PDH Antenna for WB sheet,although there are figures they are not showcasing in Final sheet an subsequently now showcasing in graph as well.

[Bob Phillips]

That is because WB is not in the list of checkboxes, I couldn't correlate that list to the worksheets.