Creating a grouping variable with a scatter plot

's Computer Specifications

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?

's Computer Specifications

Excel 2007 Bubble Chart
With macro.
http://c0718892.cdn.cloudfiles.racks.../04_08_10.xlsm
Pdf preview (3 pages):
http://www.mediafire.com/file/zbzgkymai3g/04_08_10.pdf

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3D Scatter Line Plot in Excel - Wellbore Plot	KenN	Microsoft Excel Charting	0	12th May 2011 11:21 PM
Mixing scatter plot with a category plot	Janet A. Thompson	Microsoft Excel Charting	2	1st Apr 2010 06:53 PM
XY scatter plot with multiple data pairs for each variable	=?Utf-8?B?Z3BvdGF2aW4=?=	Microsoft Excel Charting	2	5th Jun 2006 08:45 PM
creating names for data shown on a scatter plot	=?Utf-8?B?YnVkc2tp?=	Microsoft Excel Charting	1	22nd Dec 2004 05:15 PM
Scatter plot changes to line plot with data gaps	Jim	Microsoft Excel Charting	13	8th Oct 2003 05:10 PM