ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating a grouping variable with a scatter plot (https://www.excelbanter.com/charts-charting-excel/260978-creating-grouping-variable-scatter-plot.html)

UNCHeels66

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?


Herbert Seidenberg

Creating a grouping variable with a scatter plot
 
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



All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com