Hi all,

I want to use a "dot graph" to show the percentage statistical characteristic of my data. but no matter how many times I tried, I can't put them into one figure.
bellowing is my basic statistical characteristics of the data, and the number showns in variable "perceivedtoeye, perceivedtohf, tosurgerymin1, tohospitalmin1" is the observation number respectively.
sample1 timeorder perceivedtoeye perceivedtohf tosurgerymin1 tohospitalmin1
not operated Less than half an hour (30 mins) 156 173 271 12
not operated More than 0.5 hour & less than 1 hour 284 316 439 110
not operated More than 1 hour & less than 2 hours 272 298 298 643
not operated More than 2 hours 404 329 108 351
operated Less than half an hour (30 mins) 101 119 386 12
operated More than 0.5 hour & less than 1 hour 223 216 316 75
operated More than 1 hour & less than 2 hours 205 227 56 537
operated More than 2 hours 237 204 8 142

I want to show my data as the graph explained in the article "Speaking Stata: Between tables and graphs", written by Cox, The Stata Journal (2008) 8, Number 2, pp. 269–289
code: graph dot (asis) percent, over(ageorder) by(activityorder, note("") compact cols(2))--which looks simple

[ATTACH=CONFIG]temp_23788_1629477220190_1[/ATTACH]

but I can't get above result, my best code is: graph dot (percent) hh, over(perceivedtoeye) over(sample1) --and the result looks like below
what I want to do is that show all the four variables' group percentage of timeorder into one table on the same percent scale, and figures will be two since there are operated and not operated subsamples.
[ATTACH=CONFIG]temp_23789_1629477440156_651[/ATTACH]

I don't know where went wrong, so I presented my sample data as below, any help would be appreciated. thanks!


perceivedtohf perceivedtoeye tosurgerymin1 tohospitalmin1 sample1 hh
More than 0.5 hour & less than 1 hour More than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1502
Less than half an hour (30 mins) Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1260
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 51
Less than half an hour (30 mins) Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1867
More than 0.5 hour & less than 1 hour More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 84
More than 2 hours More than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1170
More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1227
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 88
More than 2 hours More than 2 hours More than 1 hour & less than 2 hours Less than half an hour (30 mins) Not Operated 681
More than 1 hour & less than 2 hours More than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 231
Less than half an hour (30 mins) Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1756
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 914
More than 2 hours More than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1411
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 464
Less than half an hour (30 mins) Less than half an hour (30 mins) More than 1 hour & less than 2 hours Less than half an hour (30 mins) Not Operated 804
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1817
More than 2 hours More than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 86
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 79
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Less than half an hour (30 mins) Operated 1304
Less than half an hour (30 mins) Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1269
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 520
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Not Operated 1022
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1713
More than 0.5 hour & less than 1 hour More than 2 hours More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) Operated 1612
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 729
Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 1019
More than 0.5 hour & less than 1 hour More than 1 hour & less than 2 hours Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Operated 1778
Less than half an hour (30 mins) Less than half an hour (30 mins) Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Not Operated 119
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 317
Less than half an hour (30 mins) Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Operated 1732
More than 2 hours More than 1 hour & less than 2 hours Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Operated 1165
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 912
More than 2 hours More than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Operated 1167
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 118
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Operated 1369
More than 2 hours More than 2 hours More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Operated 1714
More than 1 hour & less than 2 hours More than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Not Operated 278
Less than half an hour (30 mins) More than 2 hours More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 499
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Not Operated 604
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 561
More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Operated 1477
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 217
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Not Operated 500
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Not Operated 260
Less than half an hour (30 mins) Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 523
Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 117
More than 1 hour & less than 2 hours More than 2 hours Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Not Operated 273
More than 0.5 hour & less than 1 hour More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Operated 1334
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Not Operated 854
More than 1 hour & less than 2 hours More than 2 hours Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Not Operated 934
More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Operated 1275
More than 1 hour & less than 2 hours More than 2 hours More than 1 hour & less than 2 hours More than 0.5 hour & less than 1 hour Not Operated 151
More than 1 hour & less than 2 hours More than 2 hours More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Not Operated 864
More than 0.5 hour & less than 1 hour More than 0.5 hour & less than 1 hour Less than half an hour (30 mins) More than 0.5 hour & less than 1 hour Operated 1640