• 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.

Video Tutorial on Interactive Dashboard using Hyperlinks

A

ahhhmed

Member
Dear Chandoo,

I saw your Video Tutorial on Interactive Dashboard using Hyperlinks. It is very nice to be able to tell excel to behave just as we want.


My question is that

How can I link a photo capture taken by the camera tool in excel of some cells instead of the chart in your workbook?


Do I have to change the UDF?


Can you make me a t emplate, please?
 
@All, Ahhhmed


I have uploaded a small modification to Chandoo's original file which allows for the display of different chart types and even pictures.


You can find it here: http://chandoo.org/wp/wp-content/uploads/2011/07/rollover-hyperlink-with-Pics-demo.xlsm


It uses the same Camera Tool with a linked formula using Indirect technique to retrieve different Charts, Refer http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/
 
Dear Hui,

I have made a spread sheet following all the instructions in the video, I hope, but it gave me the message ( Can't open file ). You can find my file in


http://www.mediafire.com/?tk8n5vjvkbaejn6


Could you please have a look at it to see what the problem is? Thanks a lot.
 
Firstly Ahhhmed, this is a public forum, I don't work for Chandoo.org or get any rewards from my totally voluntary contributions here.

The fact that you are "Waiting still" means that no body else had looked at, understands or has time to answer it. In my case I was sleeping.

Please refrain from these style of comments here.


Now to your problem:

You haven't included a VBA module with the following code

[pre]
Code: 
Public Function highlightSeries(seriesName As Range)
Range("valSelOption") = seriesName.Value
End Function
[/pre]

Then A11 should be shifted down 1 cell as you don't have an option for Then after Welcome as you do at AC1
 
Really sorry Hui,

All I meant is that I am totally confident in your help and detailed answers. Thanks a lot for your help. I made the amendments, saved the changes but it did not work. I am using Excel 2007. Is that the reason?
 
Have a look at: https://rapidshare.com/files/288619674/Book11.xlsm

Note the location of the VBA code in the Code Module

and check the Named Formula


This should work equally in 2007 or 2010
 
You must log in or register to reply here.
Back
Top