Re: st: xlabel questions in graph bar options.

[Nick Cox <njcoxstata@gmail.com>]

Our World Bank colleagues must speak for themselves, but I have heard
presentations of their work and I don't think they ever promised to
document the details of their code. Indeed, if I recall correctly the
main thrust of what they doing includes protecting inexperienced users
from _any_ Stata details!

More importantly, I don't think the colleagues you name are members of
Statalist, so you are best advised to email them directly.

It's my understanding that the existence of value labels makes
absolutely no difference to the ordering of categories of a numeric
variable on a graph. Manifestly we can't check your data but if what
you are asserting is true, you should be able to reproduce it with
standard datasets.

If you are implying that the problematic graphs come out of the Adept
software, it seems to me that again you need to contact the authors.

Now that you have explained your problem in more detail I see even
less point in looking at -file- for this purpose. I corrected myself
from saying that -file- is inapplicable to graph files because Stata
graph files are just text files and -file- _could_ be used to process
Stata graph files. But the principle buys you nothing here in
practice: what you need is to translate .gph files to some other
format that Excel can understand, and that is already gone by -graph
export-.

You can highlight specific categories using the Graph Editor.

Nick

On Wed, Jan 2, 2013 at 5:23 PM, Amadou DIALLO <stata.diallo@gmail.com> wrote:
> Nick,
>
> In this command, X is a numeric variable based on a string one, using
> encode command, reason why I don't understand what is going on. Also,
> more generally, is it possible to highlight a particular value on a
> x-axis?
>
> The second point is that I am looping across MANY datasets to produce
> graphs and I want to insert these graphs automatically in Excel or
> Word. The point is, Adept (downloadable from the World Bank site),
> which is a Stata-based plateform, is doing (it inserts both
> pre-formatted tables and graphs in excel) this but the authors, Zurab
> Sajaia and Sergiy Radyakin, are not disclosing the stata commands
> (embedded in the exe). Maybe, as a wishlist, they can format these
> commands to make it general to the users?
>
> Third, I'll try the file command and see what happens.
>
> Thx
>
>
>
> 2013/1/2, Nick Cox <njcoxstata@gmail.com>:
>> Strictly, you could use -file- to process Stata .gph files, but I
>> can't think that would be any use in this context.
>>
>> Nick
>>
>> On Wed, Jan 2, 2013 at 4:17 PM, Nick Cox <njcoxstata@gmail.com> wrote:
>>> What would "direct to [MS E]xcel"? mean? You can -graph export- graphs
>>> in various file formats that MS Excel can read. Otherwise you can copy
>>> graphs via the Windows clipboard (I guess that you are using MS
>>> WIndows).
>>>
>>> Similar comments apply to [MS W]ord.
>>>
>>> -file- is not applicable to graph files.
>>>
>>> Nick
>>>
>>> On Wed, Jan 2, 2013 at 3:19 PM, Amadou DIALLO <stata.diallo@gmail.com>
>>> wrote:
>>>>
>>>> 3. Is there any way to export or send stata graphs directly to excel
>>>> (or to word using the file command)?
>> *
>> *   For searches and help try:
>> *   http://www.stata.com/help.cgi?search
>> *   http://www.stata.com/support/faqs/resources/statalist-faq/
>> *   http://www.ats.ucla.edu/stat/stata/
>>
>
>
> --
> Amadou B. DIALLO, PhD.
> Senior Economist, AfDB.
> a.b.diallo@afdb.org
> +21671101789
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/