Is there a way to create a link to worksheet on the dashboard. I have few products and based on the product name clicked I want to display its corresponding chart on the dashboard. Once chart is viewed I also need a way to collapse the chart dynamically clearing the space on the dashboard for any other static chart.
Actions can be used in this manner. The following link goes into more details about actions:
By choosing Exclude all values when an item is deselected will clear the view when it is not in use. Hope this helps!