Interactive DAshboard not working help needed

[kavitha]

Hello All,
I'm a newbie into excel --- i tried to create a interactive dashboard, where the bar chart are not working , please help me to fix this issue. Attaching the excel sheet for reference. thanks all

 

[Deepak]

@kavitha,
Have u checked values in col Jan,feb....
as all are same(1).

 

[kavitha]

Hello Deepak,,and the data in colu.. i have just added for reference.. I tried to fix this for nearly 2days. .but it dint work so seeking help,would be helpful if you help me fix

 

[Deepak]

Is this what u look for??

 

[kavitha]

Nope. I'm looking for a interactive bar chart - Ex: if i select owner group - COR Exchange(ibm) it should display.. the counts for COR Exchange for the month of JAN FEB MARch and April only.. ,,, if i select a particular owner grp only those data should be display

 

[Somendra Misra]

Hi Kavitha,


See the attached file. Is this what you want?

Regards,

 

[Vignesh Veerasamy]

Hi Kavitha,

One of my observation in your file was that against the drop down list,dta had to be called manually which will be the input for the graph and not the entire range of data.

Manually use Index & Match formula to call the required data and from which you can proceed with chart formation.