ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   X,Y Data values in chart (https://www.excelbanter.com/excel-discussion-misc-queries/72178-x-y-data-values-chart.html)

lgarcia3

X,Y Data values in chart
 

I need to get the values of the pair (x,y) in an YY chart with a click
event. I already get some information with the Chart_Select event
(ElementID, series, point) But dont know how to get the two values from
that point.
Thanks!


--
lgarcia3
------------------------------------------------------------------------
lgarcia3's Profile: http://www.excelforum.com/member.php...fo&userid=7488
View this thread: http://www.excelforum.com/showthread...hreadid=513353


lgarcia3

X,Y Data values in chart
 

So, any ideas about it?
Thanks!


--
lgarcia3
------------------------------------------------------------------------
lgarcia3's Profile: http://www.excelforum.com/member.php...fo&userid=7488
View this thread: http://www.excelforum.com/showthread...hreadid=513353


vezerid

X,Y Data values in chart
 
Haven't done much VBA with charts, but maybe the macro recorder will
give you a hint as to which library properties and methods pertain to
data points. From there you can extract code portions to modify your
Select procedure.

HTH
Kostis Vezerides



All times are GMT +1. The time now is 08:31 PM.

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