Plotting a chart

[Tammy]

Hello,

I have a user who sent this request:

"Can you think of any way to draw the following kind of graph?

Horizontal axis = X, vertical axis = Y.

I want to plot 20 nations by X and Y. Each nation is plotted for two years,
1980 and 2005. Thus there would be 40 points on the graph, two for each
nations (one for 1980, the other for 2005).

I’d like the graph to show an arrow for each nation, running from its 1980
coordinates to its 2005 coordinates. It would be nice to label each arrow
with the name of the nation."

Here is an example of the data he is trying to plot:

Iceland Iceland Norway Norway Australia Australia
1980 2005 1980 2005 1980 2005
X 17 20 43 48 35 41
Y 5 7 8 12 9 15

I do not have that much experience with charts, and don't know how to set
this up. Can anyone point me in the right direction, based on the information
provided above?

We are using Excel 2007.

Thanks so much!!

 

[Jon Peltier]

Make a chart with two XY series, one for 1980 and the other for 2005. Then
connect them with arrows as described in my blog:

http://peltiertech.com/WordPress/2008/05/26/connect-two-xy-series-with-arrows-vba/

- Jon