HI,
I have 8 questions I want to display the results of on one bar chart.
At the moment, when I run a frequencies query on all 8 questions, it creates a seperate bar chart for each.
I want the yes/no percentage for each question to appear in one chart... can this be done?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Also, if all of that seems too confusing, you could use this syntax:
GRAPH
/BAR(SIMPLE)=PGT(1)(yn1) PGT(1)(yn2) PGT(1)(yn3) PGT(1)(yn4) PGT(1)(yn5) PGT(1)(yn6) PGT(1)(yn7) PGT(1)(yn8)
/MISSING=LISTWISE.
Just change out "yn1" to "yn8" for your variables names, and this should work just as well (still assuming you defined 0=No and 1=Yes).
HI - when I try to add a variable to the "Bars Represent", I get an error saying that "String variables are not allowed in the list".
The 8 variables have three values 1 = "Yes", 2 = "No", 3 = "No Answer"
The questions themselves are, for example "Do you accept payments online".
The variable name for this one, for example is "DonationMechanismOnline"
The Label is "Do you accept donations online?"
See this section:
"I will add that if your values are currently text (e.g. if you actually have "Yes" and "No" in your dataset rather than numerical representations), you'll need to use the variable recode functions (under Transform) to turn them into numbers, otherwise SPSS will have no way to know that you specifically want to analyze "Yes" instead of "No."
If you already recoded your strings into numbers (i.e. if 1 2 and 3 are the values in your dataset), you'll need to go to variable view and change the variable type to "Numeric" instead of "String",
Ah. There's a setting to show Value Labels in the dataset, which it looks like you have turned on. But that probably means that you have actual numbers in your dataset (hopefully).
When you click on Variable view at the bottom (it's a tab), you should see a list of all of the variables in your dataset along with a lot of other information related to each. Under "Type" you should see the word "String" next to the variables that you are interested in using. Click one of the cells that says String and click on the triple dot button that appears in the cell (it looks like this: "..."). Select Numeric in the resulting list.
One of two things will happen. Either 1) your data will look the same in the dataset viewer (which is what we want) or 2) it was all get deleted. If it gets deleted, close the file without saving, and let me know. If it doesn't, the graphing procedure I described above should work.
In the data viewer, you shouldn't be able to see the values column... you should only be able to see that in the variable viewer.
Tell you what - I think a lot of this confusion is just due to miscommunication, so it might be easier (and faster) if you were just to post the file and I will take a look at the SAV itself. If your data is sensitive, feel free to delete all but a couple of lines of data or any identifying columns - just make sure not to change anything about the columns containing the 8 pieces of data you're interested in themselves.
Ah, sorry, "all the values are now as numbers in the data viewer...however in the values column" confused me.
Well... that will just make this a little more tricky. :)
Here's the approach then - first, delete all entries in the Values column for all variables and then tell me if you see numbers or words in the data view. Then run a FREQUENCIES analysis on each of the variables and tell me what appears in the first column of that analysis (should be either numbers or words).
You will probably want to do this on a copy of your original dataset so that you don't accidentally delete and save.
Ah! Then that's pretty easy (perhaps surprisingly!). You do indeed need to convert everything over to a numeric format. To do so:
1) Click "Recode into Same Variables" under the "Transform" menu.
-- Recode into Same Variables dialog --
2) Put all of the variables you'd like in the bar graph into the right-hand list
3) Click "Old and New Values"
-- Recode into Same Variables: Old and New Values dialog --
4) Under the "Old Value" section, put "Yes" in the blank next to Value:
5) Under the "New Value" section, put "1" in the bank next to Value:
6) Click Add
7) Under the "Old Value" section, put "No" in the blank next to Value:
8) Under the "New Value" section, put "0" in the bank next to Value:
9) Click Add
10) Click Continue
-- Recode into Same Variables dialog --
11) Click OK
12) Open the Variable pane using the tabs at the bottom
-- Variable pane --
13) Next to the first variable that you are interested in generating the graph for, click on the box under "Type" (it probably says String)
14) Click the triple dots that appear
-- Variable Type dialog --
15) Click on Numeric
16) Click OK
-- Variable pane --
17) Click on the box that just changed to Numeric (so that it is highlighted) and press Ctrl-C (to copy)
18) Click on the Type entry for the second variable you are interested in
19) Press Ctrl-V (to paste)
20) Repeat steps 18-19 for each variable you want to generate the graph for
21) Click on the box under Values for the first variable you are interested in
22) Click on the triple dots that appear
-- Value Labels dialog --
23) Enter "0" for Value and "No" for Label
24) Click Add
25) Enter "1" for Value and "Yes" for Label
26) Click Add
27) Click OK
-- Variable view --
28) Click to highlight the box under Values that just changed and press Ctrl-C (to copy)
29) Click on the Values entry for the second variable you are interested in
30) Press Ctrl-V (to paste)
31) Repeat steps 29-30 for each variable you want to generate the graph for
32) See my post above (ID: 25135597) for directions on how to generate the graph using your newly converted data
Business Accounts
Answer for Membership
by: richdiesalPosted on 2009-08-19 at 11:13:36ID: 25135597
To the moderator: I have an SPSS alert, but it didn't go off until a couple of hours before your community alert did.
Now, to mharcais...
Yes, you can, but the output is not exactly what you'd think.
For this explanation, I'm going to assume you used code 1=Yes and 0=No for 8 variables called yn1, yn2, yn3...yn8. You'd need to adjust the procedure slightly depending on differences in your own dataset.
1) Go to Bar under the Graphs menu (might be under "Legacy Dialogs" depending on your version)
-- Bar Charts Dialog --
2) Select "Summaries of separate variables" at the bottom
3) Click on "Simple"
4) Click on "Define"
-- Define Simple Bar Dialog --
5) Put yn1 to yn8 in "Bars Represent"
6) While yn1 to yn8 are still highlighted under Bars Represent, click on "Change Statistic..."
-- Statistics Dialog --
7) Click on "Percentage Above"
8) Next to Value, type "0"
9) Click on "Continue"
-- Define Simple Bar Dialog (again) --
10) Click on "OK"
-- Output Pane --
11) This graph displays all of your variables, with the percentage "Yes" in each.
12) You will probably, at the bare minimum, want to change the y-axis label ("% > 1"), which you can do by double-clicking on the chart to open the Chart Editor, clicking once on the axis label, waiting a second, and then clicking on the label again.
I will add that if your values are currently text (e.g. if you actually have "Yes" and "No" in your dataset rather than numerical representations), you'll need to use the variable recode functions (under Transform) to turn them into numbers, otherwise SPSS will have no way to know that you specifically want to analyze "Yes" instead of "No."