I am a new learner in excel macros. I am trying to export the value (x, y) of 1 point in 1 series by point one-clicking.
Ex. I have a chart X-Y with 3 points A (1, 2); B (3,4); C(5,6)..... when I click on point "A" on this chart, the X value and y Value will be defined in A1 and B1 cells
. Next, when I click a single point "B" or "C" on this chart, the X value and y Value will be updated in A1 and B1 cells. Many thanks for your help!