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

[A Loumiotis <antonis.loumiotis@gmail.com>]

Thanks Nick for your hint but I'm not sure how I can apply it to my
problem.  In this example sales and sales2 have an exact functional
relationship but usually they will not.  Playing around with graph bar
I think that the asyvars together with the stack option stacks the
bars only when there is only one yvar.  Is this correct?
Thanks,
Antonis

On Wed, Jun 30, 2010 at 3:32 PM, Nick Cox <n.j.cox@durham.ac.uk> wrote:
> 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/
>

*
*   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/