Dear all,

I am having problems with the following code:

Code:
graph dot (mean) promedio2017 promedio2018 promedio2019, over(entidad) ///
    yla(80 100 120 140) yscale(range(80 145))
I would like to spread the dots through the interval specified in the yscale option but here is the result, instead:


My data is given by

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str28 entidad int(promedio2017 promedio2018 promedio2019)
"BARRANQUILLA"         97  97  96
"BOGOTÁ D.C."         98  97  96
"BUCARAMANGA"         102 102 100
"CALI"                101 101  99
"CARTAGENA DE INDIAS"  95  96  94
"ESPINAL"              92  93  91
"MANIZALES"            91  94  91
"MEDELLÍN"           103 103 103
"NILO"                 84  84  86
"Nacional"             98  97  96
"SOLEDAD"              99 100  99
end
However, I would like my graph to look at this end like this one:


Does anyone know, perhaps, a better way to achieve this?

Kind regards in advance.