DashBoarder
New Member
- Joined
- Sep 9, 2014
- Messages
- 9
Excel 2010
Win7 Ult. SP1
Greetings to all,
I've been working on dashboards, using embedded charts - mostly bar charts. I've incorporated drill-downs such that, when a user clicks on a bar in Chart1, Chart2 responds. And when they click on a bar in Chart2, Chart3 responds. Again, these are embedded charts, and I'm using the MouseUp event to trap a chart click, then using the GetChartElement method to retrieve x, y, ElementID, Arg1 and Arg2 - with Arg2 being the primary parameter that I use. Things are working pretty well, and I'm almost ready to roll out these dashboards to my users. But these users run the gamut of experience, so anything can happen.
Here's my question: how can I lock down these charts such that users cannot move, delete, or otherwise screw up my dashboard, BUT STILL be able to click on the charts and have them respond?
I've been assuming that this is a problem that can be solved, and so have left it as a final step in my development process. PLEASE tell me that this was not a mistake, and that I can allow for the charts to respond to clicks, but still have a sufficient measure of protection! If you need further info, just let me know.
Thanks!
Win7 Ult. SP1
Greetings to all,
I've been working on dashboards, using embedded charts - mostly bar charts. I've incorporated drill-downs such that, when a user clicks on a bar in Chart1, Chart2 responds. And when they click on a bar in Chart2, Chart3 responds. Again, these are embedded charts, and I'm using the MouseUp event to trap a chart click, then using the GetChartElement method to retrieve x, y, ElementID, Arg1 and Arg2 - with Arg2 being the primary parameter that I use. Things are working pretty well, and I'm almost ready to roll out these dashboards to my users. But these users run the gamut of experience, so anything can happen.
Here's my question: how can I lock down these charts such that users cannot move, delete, or otherwise screw up my dashboard, BUT STILL be able to click on the charts and have them respond?
I've been assuming that this is a problem that can be solved, and so have left it as a final step in my development process. PLEASE tell me that this was not a mistake, and that I can allow for the charts to respond to clicks, but still have a sufficient measure of protection! If you need further info, just let me know.
Thanks!
