Hi all,
I have very basic question that I cannot find an answer to. I have tried all sorts of options from stacked bar chart to caplets, but can't seem to figure out how to make a chart that's very simple in Excel! The chart I am trying to create is something like the one attached here. Basically, it's survey data- Each of the bars are different variables that rate an organization's performance on those items from highly unsatisfactory (-2) to highly satisfactory (+2 ). Each of the rows is ratings by respondents. I can do one bar at a time, but I would like all bars to be in the same chart for compact presentation. Anyway to do this in Stata or should I export data to Excel for this? So, basically each of the slices in a bar would be the frequency of each category of responses within a variable (e.g., 10 highly unsatisfactory, 5 unsatisfactory.... on var1, etc.)

Any help will be most appreciated. Thanks.

The data is as follows:
ID var1 var2 var3 var4 var5 var6
1 -2 1 0 -1 2 1
2 2 1 0 1 2 1
3 2 1 0 -1 2- 1
4 -2 1 0 -1 2- -1

Array