linking to a graph

tealeaf · May 20th, 2002, 11:02 AM

is it possible to hyperlink to a graph in the same file.

Damon Ostrander · May 20th, 2002, 05:35 PM

Hi tealeaf,

No, I don't believe so. However, it is possible without using a hyperlink to make a cell or drawing object behave as if it were hyperlinked to a chart. This is done via VBA code. To "hyperlink" a cell this way simply requires a line of code like

Worksheets("Sheet 5").ChartObjects("Chart 1").Select

in the worksheet's Change event. To "hyperlink" a drawing object this way simply put this code into a macro, and assign the macro to the drawing object.

May 20th, 2002, 05:35 PM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi tealeaf, No, I don't believe so. However, it is possible without using a hyperlink to make a cell or drawing object behave as if it were hyperlinked to a chart. This is done via VBA code. To "hyperlink" a cell this way simply requires a line of code like Worksheets("Sheet 5").ChartObjects("Chart 1").Select in the worksheet's Change event. To "hyperlink" a drawing object this way simply put this code into a macro, and assign the macro to the drawing object. __________________ Keep Excelling. Damon VBAexpert Excel Consulting (My other life: http://damonostrander.com )

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 11:02 AM	#1
tealeaf Board Regular Join Date: May 2002 Location: mtl, canada Posts: 160	is it possible to hyperlink to a graph in the same file.