ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel 2002 : question on hyperlinks (https://www.excelbanter.com/new-users-excel/12802-re-excel-2002-question-hyperlinks.html)

nbrcrunch

Excel 2002 : question on hyperlinks
 

This is not exactly what you asked for but it does enable you to specify
a target link with a chart to a Sheet.

1. Start with the chart inside a Sheet
2. Use the camera icon to take a picture of a cell or range. Tools,
Customize. Category: Tools; Commands: Camera icon

3. Click where ever to place the image
4. Link the image to where it needs to go.
5. right-click & choose Copy
6. Select the frame of the chart object.
7. Right-click and choose paste
8. Again, select frame of chart object, right-click and choose
"Location"
9. Put the Chart on its own Chart-type (tab).
10. The link should work


--
nbrcrunch


All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com