This content has been marked as final. Show 2 replies
i have 2 sheets , the summary sheet and the details sheet. Summary sheet contains a bar chart showing 'Region vs Sales'.and the details sheet contains individual datewise sale records of all regions . I want a functionality like :
When i click on any bar corresponding to a particular region it should go to the next sheet automatically filtering the details only for that particular region.
Can anyone help me on this?
Thanks in advance