We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
I guess you could assign a macro to the chart click event and then test the mouse position co-ords to see if it was in the right area and then do what you need to do but doesn't really fall into the remit of "easy"
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
that's why I always prefix things like this with AFAIK because every single time I say that something cannot be done, I get proved wrong. I should learn really ;-)
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
no real need for vba unless you need to automate the creation of chart and hyperlink
Simply add a new rectangle from the shapes collection and right click to add a hyperlink. then, drag it over the chart to where you want it to be and set its border colour to none and interior colour to none. It will look like it isn;t there but if you click on it, the hyperlink will be activated...
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
There is no vba here - add any shape onto the chart (or worksheet) and right-click it. From the popup menu you can both add a hyperlink and format the shape (remove border and filling).
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
If you are using a Chart Object, as opposed to a ChartObject Object, you can easily use the GetChartElement Method in the Chart_MouseDown event.
If you are using a ChartObject Object, you must create a class module for your Chart in the ChartObject in order to expose the events for that ChartObject's Chart Object.
Using the GetChartElement Method, you can, for instance, click on a series point and know which series and which point in that series was selected.
Skip, To be safe on the [red]FOURTH[/red], Don't take a [red]FIFTH[/red] on the [red]THIRD[/red] Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red] [red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.