manishc1989
New Member
- Joined
- Aug 11, 2013
- Messages
- 32
I have built up a dashboard in Excel 2016 which is currently showing the data for past two weeks.
But I want to make it more interactive by adding arrows which increment and decrements the range by two weeks and so forth, when user clicks on the arrow.
One way which I can think of, If I am able to change the cell value by one, each time when user clicks on the pointed arrows and set up a link between source data and main sheet with that cell value.
Actually, this dashboard is seen by our stakeholders in Excel Online SharePoint. As you know it does not support scroll bar and also I cannot use VBA to perform this activity.
I know it's challenging to do it without VBA or inbuilt scroll bar, but I know you can suggest me a solution of doing it.
I hope I am able to clearly explain the problem. I am happy if I can help with any other details.
But I want to make it more interactive by adding arrows which increment and decrements the range by two weeks and so forth, when user clicks on the arrow.
One way which I can think of, If I am able to change the cell value by one, each time when user clicks on the pointed arrows and set up a link between source data and main sheet with that cell value.
Actually, this dashboard is seen by our stakeholders in Excel Online SharePoint. As you know it does not support scroll bar and also I cannot use VBA to perform this activity.
I know it's challenging to do it without VBA or inbuilt scroll bar, but I know you can suggest me a solution of doing it.
I hope I am able to clearly explain the problem. I am happy if I can help with any other details.