View Single Post
  #1   Report Post  
Mark Stephens
 
Posts: n/a
Default Clickable pie chart - anyone know how this might be achieved?

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