Evolution of scatter dots

[Guest]

Hi,

I am trying to create a scatter graph which allows me to show the evolution
of several teams on a scatter plot.

I have two data per team (rank and goals). Rank must be the Y axis and goals
the X axis. That should be perfect for a scatter, but I want to show the
evolution of each team between two different years.

1990 2003
Goals Rank Goals Rank
teamA 10 5 9 3
teamB 9 3 19 1
teamC 10 4 5 6
teamD 12 1 2 10
teamE 10 2 1 13
etc.

I want to see a scattergraph with a line linking the dot of team A in 1990
with the dot of the same team 13 years later.

Any idea?

Thanx!

 

[Jon Peltier]

You need to make a scatter chart with one series for each team. If the two years for each are
the same, it should not be easily misunderstood.

Rearrange the data like this:

TeamA Goals Rank
1990 10 5
2003 9 3

Make a chart with the 10-5/9-3 data for Team A, and use the cell with the team name for the
series name. One by one, add corresponding series for the other teams. Then you can use the
Label Last Point macro from here to label each series in the chart with the team name:

http://peltiertech.com/Excel/Charts/LabelLastPoint.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______