This morning, one of the managers asked me about putting some hyperlinks in
chart objects.

So, I did a little research, and see from several sources, that you can't
directly put hyperlinks in charts, you have to sort of fake it out by
actually assigning the hyperlink to a cell range where the chart is located.

But, why does the chart object have a hyperlinks property, if this is true?

(I'm not doubting the sources, I just don't see what the point of the
HyperLinks property is, if you can't use it)

Help my thinking?

While you cannot assign a hperlink to a chart, you can assign a macro to the
chart and have the macro do the hyperlinking for you.
--
Gary''s Student - gsnu200857


"mark" wrote:

This morning, one of the managers asked me about putting some hyperlinks in
chart objects.

So, I did a little research, and see from several sources, that you can't
directly put hyperlinks in charts, you have to sort of fake it out by
actually assigning the hyperlink to a cell range where the chart is located.

But, why does the chart object have a hyperlinks property, if this is true?

(I'm not doubting the sources, I just don't see what the point of the
HyperLinks property is, if you can't use it)

Help my thinking?

right... I've thought of that. thanks.

but, do you understand what the purpose of the chart object having a
HyperLinks property is, if you can't use it?

"Gary''s Student" wrote:

While you cannot assign a hperlink to a chart, you can assign a macro to the
chart and have the macro do the hyperlinking for you.
--
Gary''s Student - gsnu200857


"mark" wrote:

This morning, one of the managers asked me about putting some hyperlinks in
chart objects.

So, I did a little research, and see from several sources, that you can't
directly put hyperlinks in charts, you have to sort of fake it out by
actually assigning the hyperlink to a cell range where the chart is located.

But, why does the chart object have a hyperlinks property, if this is true?

(I'm not doubting the sources, I just don't see what the point of the
HyperLinks property is, if you can't use it)

Help my thinking?