• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink to Sheet created by Moving Chart - Problem

ashfire

New Member
Ive created plenty of charts in excel 2007 and Move Chart – New sheet. These are then referenced in a powerpoint show with no problem.

Because I want to quickly move to a chart ive created a dashboard with a shapes and which I want to hyperlink to the relevant chart.

However when I tr to insert a hyperlink to place in this document none of the graph sheets are available. (all sheets that were created normally are)


Is there a way around this ?


cheers
 
Ashfire

There is no way to directly do what you want

There is a work around

insert a macro like below on a module page

[pre]
Code:
Sub Shape1_Click()
Charts("Chart1").Activate
'Change the Chart name to suit
End Sub
[/pre]

Then right click on your shape and Assign a Macro to your shape

Select the macro name you just pasted


You can make the Shapes Text Blue and Underline to make it look like a Hyperlink
 
Back
Top