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