Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
As far as I understand it can't be set up as an automatic link. So the options are
Hi Robert,
Thank you for the reply.
But is it possible for some workaround where we can directly click on the bar and the navigation get triggered.?