RE: st: AW: Is it possible to create a bar graph with two yvars

["Nick Cox" <n.j.cox@durham.ac.uk>]

You may need to -reshape- so that -sales- and -sales2- become one quantitative and one categorical variable. 

Nick 
n.j.cox@durham.ac.uk 

A Loumiotis

Thanks for your help Martin.
By omitting the stack option I do not get what I want.  I would like a
bar graph of sales and sales2 on the yaxis, time on the x-axis and the
bars stacked by sector.  For each time period I would like to have two
"stacked (by sector)" bars, one bar for sales and one for sales2.
Your suggestion creates six bars for each time period and not two
stacked bars.

Martin Weiss 

> Omit the -stack- option in the second call...

A Loumiotis

> I use a variation of an example by Nick Cox to ask my question:
>
> clear
> set obs 1000
> egen id = seq(), block(10)
> egen time = seq(), to(10)
> format time %tq
> gen time2=string(time, "%tq")
> gen sector = ceil(3 * runiform())
> bysort id: replace sector=sector[1]
> label define sector 1 "SECTOR 1" 2 "SECTOR 2" 3 "SECTOR 3"
> label values sector sector
> gen sales=exp(rnormal())*1000
> gen sales2=2*sales
> graph bar (sum) sales, over(sector) over(time2,
> label(labsize(vsmall))) asyvars stack legend(size(vsmall))
> graph bar (sum) sales (sum) sales2, over(sector) over(time2,
> label(labsize(vsmall))) asyvars stack legend(size(vsmall))
>
>
> At the end of the code I'm generating two graph bars.  The first one
> has the variable sales as yvar where the bars are stacked by sector
> and time is the xvar.
> What I would like to do is to generate an analogous graph but with two
> yvars instead of one, sales and sales2.  So for each period I would
> like to have two bars, one for sales and one for sales2.  However, my
> second graph bar command does not achieve this. Is it possible to do
> this with graph bar?  If yes, what am I doing wrong?

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/