Scatter Charts


Posted by Tom on January 30, 2001 1:19 PM

I'm trying to plot a scatter chart and I can't get it to do what I want. Assuming I have the data below

State 1998 1999
AL -2 +1
AZ -5 +2
GA -2 -3

I want the chart to have the x-axis be -5 to +5 and the y-axis to be +5 to -5.

Then I want to plot where the states fall with this grid. AL would be plotted at -2, +1. AZ at -5, +2, GA at -2, -3, etc. But I don't want the numbers to be plotted, I want the State Abrev. to be plotted. Like so;

y-axis

5
4
3
AZ 2
AL 1
x-axis -5 -4 -3 -2 -1 0 1 2 3 4 5
-1
-2
GA -3
-4
-5

Is this possible. And if so, how?

Thanks,

Tom



Posted by Tim Francis-Wright on January 30, 2001 2:16 PM

y-axis 4 3


Check out the following link on Aaron Blood's
site:

http://www.geocities.com/SiliconValley/Hills/6814/Addins/XY_Labels.zip

This will load an add-in that, on running,
will ask you for the label series.

You can set the X and Y axes manually to
begin and end at -5 and 5, respectively.
Finally, you can set the markers on the data
series to None.

Good luck!