I want to double click on a segment of the piechart like a macro/hyperlink

[Muzza86]

i am trying to have a pie chart on my spread sheet, where each segment acts as a macro/hyperlink so that when I click/double click on it, it opens up a file.

I tried to use the shapename application caller in vba to address this but you cant figure out the name of a SEGMENT , just the entire graph.

is this possible?

[Miroslav R.]

Hi there,
You can perfectly manage that when you move Your chart from excel sheet to chart sheet.
There are many options (events) you can manage via VBA on chart sheet.
For example, You can use 'BeforeDoubleclick' or my favourite 'Mousemove' event.

It is worth a look (maybe a little workout how to process all the arguments will be necessary)

Hope it helps

M

[Muzza86]

I can achieve rollover mouse effects on cells - is it the same?

got to be honest, I don't know what you mean by a chart sheet? how do I get into that mode?

[Miroslav R.]

No. It is not possible to have a mousemove event on regular excel sheet (the sheet with cells :-) ). At least not without activated coursor API (but so far I know, coursor API knows only the possition of coursor on the screen, but not the cell range).
Mostly I use doubleclick event on excel sheet (this event contain 'Target' range - or if You want the range of cell you doubleclicked) and with a little testing for target.row and target.column, you it can be folowed by any procedures You want.

Chart sheet:
You have source data in cells on sheet. When You create a chart by default it appears on the same sheet - it is a object in sheet. But there is an option to move this chart to new sheet - chart sheet ('move chart' in chart right click menu). On this new sheet, the chart is displayed in full screen mode and have many new options as described in my first reply.

Hope I wrote it understandable.

M

[Andy Pope]

For a chart object you need to create a class to capture the events.

[Muzza86]

@andy - wow your a lot better at this than me lol

[Muzza86]

miroslav - you CAN do a mouseover effect in regular excel sheet - on the cells (not chart).... ive done it

[Dicerorhinus]

Andy this is great. I am googling this for last 3 hours..Many thanks!!