| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mixing scatter plot with a category plot | Charts and Charting in Excel | |||
| Scatter Plot? | Excel Discussion (Misc queries) | |||
| XY scatter plot with multiple data pairs for each variable | Charts and Charting in Excel | |||
| Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
| creating names for data shown on a scatter plot | Charts and Charting in Excel | |||
Linear Mode
