How to go from Image to corresponding Data

[Aditya M]

Hello,

I have MS Office Excel2010.


Want to know how to go to corresponding data by simply clicking on Image or Inserted picture in excelsheet.(Image and Data are on the same sheet)

For example If I have image then by clicking on particular section of that Image how to go to corresponding Table or Data.

[xor]

Right click your image.
In the drop down press Hyperlink.
In the Hyperlink dialog box press Place in This Document.
In the field Type the cell reference, write the reference where the corresponding table starts.
Press OK.

[Aditya M]

Hey, xor

I tried your suggestion, for entire image it is working.but if I want to do section wise then?

For example in the same image but want to give hyperlink section wise,that means If I click on left side section of the image then it should go to corresponding cell reference which I have kept for it.& for right side section on the same image it should go to corresponding cell reference which I have kept for it.

Thanks!

[xor]

Originally Posted by Aditya M

I tried your suggestion, for entire image it is working.but if I want to do section wise then?

For example in the same image but want to give hyperlink section wise,that means If I click on left side section of the image then it should go to corresponding cell reference which I have kept for it.& for right side section on the same image it should go to corresponding cell reference which I have kept for it.

Thanks!

You cannot do that in the same image.
I have made an example with two shapes which might inspire.