ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get datapoint number? (https://www.excelbanter.com/excel-programming/338918-how-get-datapoint-number.html)

boh

How to get datapoint number?
 
Hi.
I have two charts, Chart 8 and Chart 9, aligned.
Chart 8 is an Aerachart, chart 9 is a XY (Scatter) chart.
When I click on a XY-point, I get correct seriesnumber, pointnumber..
But, when I click beside the XY-points, I would like to get the
seriesnumber, pointnumber from the aerachart.

AcitveSheet.ChartObjects("Chart 8").Chart.GetChartElement X, Y, ElementID,
Arg1, Arg2 gives correct ElementID and Arg1 but Arg2 = -1. How can I get the
"pointnumber" to Arg 2?

All help greatly appreciated / boh


All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com