Respected Seniors!
I am using the MS Excel 2013 pivot bar chart to to show some information on yearly basis. I have used the year values as "filter". Everything is working fine, except that I want to restrict the filter selection to one value (i.e. year) instead of multiple values selection at one time. As this is custom requirement, i dont know how to approach this. I need just direction only. I shall be obliged. Thanks.
I am using the MS Excel 2013 pivot bar chart to to show some information on yearly basis. I have used the year values as "filter". Everything is working fine, except that I want to restrict the filter selection to one value (i.e. year) instead of multiple values selection at one time. As this is custom requirement, i dont know how to approach this. I need just direction only. I shall be obliged. Thanks.