Series Point locations on chart

**nupurgupta123** · 03-15-2010, 12:19 PM

I have a chart with a few series. I need to draw some lines beginning from some points on some of the series.

I am using a function I read about - GET.CHART.ITEM.
However, it is working only intermittently. Anyone with experience of this please??

Thanks a lot.

**Andy Pope** · 03-15-2010, 01:28 PM

We need more information.

What chart type do you have?
What points should you be drawing between?

Can you post example of what you currently have.

**nupurgupta123** · 03-15-2010, 03:44 PM

In the attached example, I have a stacked column chart based on a table of data. I have drawn an arrow by hand on it. I need to draw this arrow programmatically.

That is, I need to figure out the coordinates of a point on a series e.g. Series2Point5, and draw the arrow connecting the upper-left corner of the plot area to that point. This does not work for this point, but works for some others!

(The code to draw the arrow is included in the vba part of the excel file, I picked it up from the internet.)

**Andy Pope** · 03-16-2010, 05:57 AM

You need to fix the Value axis scale otherwise plotting the xy-scatter series to the top left corner will cause the scale to auto adjust.

I have drawn a line from top left to point 5 and then on to point 7.