Categorical variables (integer values) imported from excel

[todd frankeParticipant]

I am new to datagraph so if there is an example for me to follow, please let me know.  I have several categorical variables, for example, race.  there are 1200 responses, coded 1-6 (integers) and exact number presents a particular self-identified racial/ethnic group.  I would like to create a pie chart of the percentages and have the numbers 1-6, labeled.  I would then like to create a stacked bar chart of this same information based on a second variable, gender identity, and create stacked bars of race/ethnicity by gender identity.  Gender identity is an integer 1-4.

 

I saw an example of how to do it with summary information but I am trying to do this with the actual responses.  Thank you.

[dgteamModerator]

The Pie command will calculate percentages based on the totals but, as you may have realized, cannot use the raw data. Instead, the Pivot command is used to perform the counts from a raw data set.  Then the output from the Pivot is used to draw the Pie charts.

We just uploaded a new example file called ‘COUNT CATEGORICAL DATA’ that walks through this process.  Go to File > On-line examples in DataGraph.

Please take a look at this example (we added instructions in the file) and let us know if this helps or any other questions you have. This may not mimic your data exactly, but hopefully shows you the process of using the Pivot command to process your data.

Here is one of the graphs in this file.

[Author]

Posts