Digita
05-22-2008, 10:49 PM
Hi guys,
I have a line chart containing a series of 12 monthly periods. I can loop through the elements under the chart collection to obtain all values of the series.
As we hover the mouse over the line graph, a small box pops up showing the values of the x & y axis of any point. Using VBA, how can we quickly extract the x & y values pertaining to a single point? Something similar to extracting the contents of a comment box from a current cell perhaps?
Thanks in advance for your response.
Regards
kp
I have a line chart containing a series of 12 monthly periods. I can loop through the elements under the chart collection to obtain all values of the series.
As we hover the mouse over the line graph, a small box pops up showing the values of the x & y axis of any point. Using VBA, how can we quickly extract the x & y values pertaining to a single point? Something similar to extracting the contents of a comment box from a current cell perhaps?
Thanks in advance for your response.
Regards
kp