Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am looking for suggestions and information on how to add a link in a chart or even a specific field in a chart that would jump to another sheet in the QVW. Is something like this possible and if so, how can it be accomplished. Thanks!
You can accomplish it by using any objects or events that can trigger an action. For example:
- a transparent button that's positioned on top of the chart (or some portion of the chart) that triggers an action
- A selection in a field that triggers an action
Unfortunately, there are no Chart elements that can be directly linked to an Action - for example, you can't trigger an action when you click on a specific cell... So, you'll need to use work around solutions like those that I brought up earlier...
I assume these actions are those that are only available with version 9. We are currently still on version 8.5, at least until a few months after version 10 is released. Can this be accomplised with this older version?
Well, in the oder versions you'd have to use VBScript/JScript Macros to accomplish the same, and those are less attractive as a solution, from a variety of different perspectives...
In anticipation of the coming upgrade, I'd recommend delaying this particular feature till you can upgrade to the newer version. The alternative is very time-consuming, proven to hurt performance, and all the work will be thrown away after the upgrade...
Hi
You Can use macro for this if u r using version 8.5.
Please define this macro,change the sheet no as your requirement.
sub Test
ActiveDocument.Sheets("SH03").Activate
end sub
please go to the following steps:-
1.Go to the setting >>Document properties >> Trigger
2. Go to field you want to event trigger >> click "on select" >> call the macro defined
Regards,
Ravi