Would like to have a chart pop up when hovering over a link

[sray]

I have a sheet of data, that lists various different models o
photocopiers, with their forecast and actual sales figures. For eac
of these different models, they have their own line graph in differen
worksheets. However, instead of having to change between eac
worksheet to view the graphs, is there anyway I could click on the nam
of the model in the data sheet, and the graph would pop up? or can
just create a hyperlink somehow??

Thanks

 

[Jon Peltier]

Embed the charts in a worksheet, and make a hyperlink to the range of
cells under the chart. Put a hyperlink next to the chart back to the
original link.

Advanced: You could pop up a userform which shows a picture of the
chart, using one of these techniques:

http://j-walk.com/ss/excel/tips/tip66.htm
http://bmsltd.ie/DLCount/DLCount.asp?file=PastePicture.zip

The first is pretty easy, the second harder but very powerful.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[sray]

Embed the charts in a worksheet, and make a hyperlink to the rang
of
cells under the chart. Put a hyperlink next to the chart back to the
original link.

Advanced: You could pop up a userform which shows a picture of the
chart, using one of these techniques:

http://j-walk.com/ss/excel/tips/tip66.htm
http://bmsltd.ie/DLCount/DLCount.asp?file=PastePicture.zip

The first is pretty easy, the second harder but very powerful.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

I tried the first way, but it was not what the customer wanted! Th
second solution is exactly what I'm looking for!!! many thanks fo
your help