Help creating a bar graph over multiple variables

[Mateo Podesta]

Greetings,
When creating a graph bar and dividing it over a variable, I cant figure out a way to add in the same graph a bar for the whole dataset. Something like this:

I have tried creating a variable "whole" and use the over two times when generating the graph but that doesnt seem to work.

gen whole = 1
graph bar una_tic todas_tic, over(area_estudio) over(whole)

Here, una_tic and todas_tic are the variables im interested on taking the mean of. area_estudio is the variable that divides my dataset

Any help is appreciated

Mateo Podesta

[Daniel Shin]

Maybe expand the dataset to create a "whole" category for area_estudio:

expand 2, gen(whole)
replace area_estudio="Total" if whole==1 // assuming it is currently coded as string
graph bar una_tic todas_tic, over(area_estudio)

[Mateo Podesta]

Thanks, Daniel. It worked!