Connect points in two different series on scatter graph

**sa02000** · 02-06-2009, 10:08 AM

Please see attached excel file for example.

I have a scatter graph with two series plotted on it. I use an x-y labeler to label these points (but I hvaen't done that in the attached file) that I found on this forum.

Now I would like to draw an arrow from november points to december points to show how monthly data changed. So in the attached file there would be total of 8 arrows. This is only part of data that I have. I have lot more than 8 points for each month and I have lot of these graphs for different categories which is why I am looking for an automatic way to do this every month as I update the data.

Does anyone know how I can achieve this?

Thank you very much in advance,
Jay

**Andy Pope** · 02-06-2009, 10:56 AM

Have a look at the attached.

Rather than arrow heads I just coloured lines.

You will need to build the data for each set of connecting series.

**sa02000** · 04-10-2009, 12:30 PM

very creative solution. Thank you. Any way to make these lines an arrow as otherwise its impossible to tell which direction did the movement happen.

Jay