CCHARTSELECTIONS - horizontal or vertical
The CCHARTSELECTIONS formula requires a horizontal range of cells in which to reside. With dashboards that we are creating, we are using 'buttons' (created by way of a stacked bar chart) for department, employment basis, or other 'filters' to slice data - and are placing these down the left-hand side of the dashboard.
It would be great to be able to host the CCHARTSELECTIONS option in a vertical range of cells rather than needing a horizontal range. This would mean that down the left-hand side of dashboards we can have the drill/filters AND the chart selections controls, rather than having to take up valuable real estate in the main 'information' part of the dashboard.
It would also be helpful to be able to include CCHARTSELECTIONS more than once on a dashboard. For a large dashboard, being able to have controls at top and bottom would be good.