• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can this even be done? Hyperlinks, Toggling Charts and/or Hiding/Showing Charts

L

Linwe

New Member
Hi there! Love this site. I have a worksheet and I used this great hyperlinking technique to dynamically change the charts http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/.


Everything is looking phenomenal on my dasboard...except I've run into a problem with the last series of data or indicator: it requires a different chart type from the others. I want to either be able to change the chart type in this one instance when this one indicator is moused over, or I want the chart to pop up (unhide) over the existing chart when it is moused over, then hide again when the hyperlink is not moused over.. so I'm thinking there is some vba I could use, or maybe some complex formulas and use of camera tool. Either way..I don't think I can figure this out on my own so any help or suggestions would be greatly appreciated!


Regards, Linwe
 
@Linwe


You can either use the camera tool for this or you can use formulas. If you use formulas, the new graph must have a similar axis. The reason is because you are going to share the new type of graph with the same space as the existing graphs. One advantage to using the formulas method is that it looks cleaner. Alternatively, you can use the camera tool. With the camera tool, you don't have to share the same graph, but the "pictures" of your graphs from the camera tool might look stretched or uneven. For your reference, I've enclosed both ways of doing what you want in the following file:


https://docs.google.com/file/d/0B1OBNnu3ZbL0WVFBVmdMU2Eybnc/edit?usp=sharing


For the formula way, the trick is to add and extra series onto the existing chart. In the example I've provided, I test which of the rollovers is selected. If it's the last series, I make the old graph turn its values to zero (effectively hiding it). The new graph then gets turned on in a very similar way. When another series is selected, the opposite happens: the new graph's values flip-off.


For the camera tool method, I've replaced the chart in the middle with the results of the camera tool. If you look into the rollover code, you will see that I test if the last series is selected. When it is, I tell the camera tool to point to a pie chart; when it's not, I tell the camera tool to point to a bar chart.


Please let me know if this information helps.
 
That is so cool Jordan! Thank you...I am examining your chart right now. I agree the formula method looks better. I might not be able to use that option however, as the first four indicators use a different axis to display the information than the last..I will play around with this though. I can't thank you enough for getting back to me so quickly and with such great solutions.


Regards,

Linwe
 
You must log in or register to reply here.
Back
Top