Hello all,

I am trying to produce a vertical bar graph using 3 categorical variables:

1. numeracy (measure of respondents' financial literacy level): 5 categories
2. gender: 2 categories
3 country: 4 categories

I want to display the percentage distibution for male and female that have numeracy==5 in each country in a single graph (for each country I want two bars, one for male and one for female).
Using
Code:
tab3way numeracy gender country, colpct
I obtain the following table with the values that I want to plot (e.g. for Austria I want to plot two bars: 28.89% for male and 20.52% for female).

--------------------------------------------------------------------------------
| Country identifier and Male or female
| --- Austria -- --- Germany -- --- Sweden --- - Netherland -
numeracy | Male Female Male Female Male Female Male Female
----------+---------------------------------------------------------------------
1 | 177 369 277 525 127 329 175 366
| 5.95 8.86 5.97 9.95 3.24 7.45 4.82 8.54
|
2 | 73 209 201 434 128 336 141 368
| 2.46 5.02 4.33 8.23 3.27 7.61 3.88 8.58
|
3 | 509 888 930 1295 1172 1541 797 1384
| 17.12 21.31 20.05 24.55 29.94 34.90 21.94 32.28
|
4 | 1355 1846 1959 2108 1221 1442 1115 1215
| 45.58 44.30 42.23 39.95 31.20 32.65 30.70 28.34
|
5 | 859 855 1272 914 1266 768 1404 954
| 28.89 20.52 27.42 17.32 32.35 17.39 38.66 22.25
--------------------------------------------------------------------------------

By using this
Code:
mylabels 0(20)80, myscale(@) local(pctlabel) suffix("%")
splitvallabels numeracy, length(5) nobreak recode
catplot gender country numeracy if numeracy==5, percent(country) legend(ring(0) position(10)) asyvars recast(bar) var2opts(label(ang(45))) ytitle("")
I obtained the row percentages, I want to obtain a similiar graph but with column instead of row percentages.

Thanks for your help!
Elisa