View Single Post
  #1  
Old April 8th, 2010, 01:31 PM posted to microsoft.public.excel.charting
UNCHeels66
external usenet poster
 
Posts: 1
Default Creating a grouping variable with a scatter plot

I have the following data:

Very Little Somewhat Moderate A Great Deal
No Strongly Disagree 1 0 0
0
Somewhat Disagree 0 0 0
0
Somewhat Agree 1 0 1
0
Somewhat Disagree 1 0 0
0
Yes Strongly Disagree 0 2 1
1
Somewhat Disagree 0 1 1
0
Somewhat Agree 0 10 5
3
Somewhat Disagree 3 16 51
19


I need the "Agree/Disagree" part on one axis and "very little-a great deal"
on the other axis and I want it grouped by "yes/no"

I can't figure out for the life of me how to do it. Does anybody know if
this is possible?