Hey Andy,

Works like a dream, you've bought a very nice smile to my face:) thanks very
much for that



"Andy Pope" wrote in message
...
Hi,

You can make use of the doubleclick event.

Take a look at John's article on hi-liting lines in a chart.
http://www.pdbook.com/index.php/excel/comment/635/

Using that as a base add this code. Then once the Connect routine has been
run try selecting a slicing and doubleclicking it.

Private Sub Cht_BeforeDoubleClick(ByVal ElementID As Long, _
ByVal Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)

If ElementID = xlSeries Then
If Arg2 0 Then
MsgBox "Run a macro for Slice " & Arg2
Cancel = True
End If
End If
End Sub

Cheers
Andy

Mark Stephens wrote:
I want to do a 3D pie chart embedded in a work sheet and allow each piece
if the pie to be 'clickable' i.e run a designated macro when clicked.

One way that occurs to me (but hard in itself) would be to put an
invisible cover (autoshape) over the piece and then assign the macro to
it; but how would I go about matching its size and shape to the correct
dimension and position of the pie peice?

Another compromise (if as I think my ideal way is impossible) would be to
try and detect the label position (less variable than the pie piece and a
convenient rectangle) and then place an invisible cover over the label
and then assign the macro with and 'on action' command.

There's usually a way of achieveing most anything but this seems to be a
tough one, any suggestions appreciated.

Kind regards, Mark Stephens

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info