Can a chart also be a macro button?

[reece1984]

Hi All,

I'm using many small charts on a single worksheet to display information to the client. I would like to make this more interactive, ideally with the user being able to click on a chart and be taken to a worksheet containing more detailed data. I think that the question is then essentially, can a chart be used as a macro button, or if not then is there a way around this, such as perhaps have a see through macro button on top of the charts or something?

I'm open to any ideas, thank you for any advice on this.

J

 

[VoG]

If you right click a chart you should see the option "Assign Macro". You could assign code like this

Sub etest()
Sheets("Sheet2").Select
End Sub

 

[reece1984]

VoG,

thanks very much, that's all I needed.

J