I have a four columns in my data set. They are: File Name, X, Y, and a URL link column.
[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]File Name[/TD]
[TD]X_value[/TD]
[TD]Y_value[/TD]
[TD]URL[/TD]
[/TR]
[TR]
[TD]File1[/TD]
[TD]2[/TD]
[TD]9[/TD]
[TD]url.com/file1[/TD]
[/TR]
[TR]
[TD]File2[/TD]
[TD]1[/TD]
[TD]7[/TD]
[TD]url.com/file2[/TD]
[/TR]
[TR]
[TD]File3[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD]url.com/file3[/TD]
[/TR]
</tbody>[/TABLE]
After creating a scatter plot of the X/Y values; I would like to be able to click that data point on the chart and have it open the associated file name URL in my browser.
I found a VBA posts where Excel will prompt the user with all the data after clicking the chart data point but it does not open the link.
[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]File Name[/TD]
[TD]X_value[/TD]
[TD]Y_value[/TD]
[TD]URL[/TD]
[/TR]
[TR]
[TD]File1[/TD]
[TD]2[/TD]
[TD]9[/TD]
[TD]url.com/file1[/TD]
[/TR]
[TR]
[TD]File2[/TD]
[TD]1[/TD]
[TD]7[/TD]
[TD]url.com/file2[/TD]
[/TR]
[TR]
[TD]File3[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD]url.com/file3[/TD]
[/TR]
</tbody>[/TABLE]
After creating a scatter plot of the X/Y values; I would like to be able to click that data point on the chart and have it open the associated file name URL in my browser.
I found a VBA posts where Excel will prompt the user with all the data after clicking the chart data point but it does not open the link.