in reply to Creating Multiple Excel Graphs on different Sheets

Looks like you tried most everything, except explicity naming the sheet, try
$Chart->Location('xlLocationAsObject', "Sheet1");

[download]

Hope it works, I don't see the rest of your stuff. I tried this on VB and it moved the chart.

JamesNC

Replies are listed 'Best First'.
Re: Re: Creating Multiple Excel Graphs on different Sheets
by Anonymous Monk on Feb 19, 2004 at 15:42 UTC
    James,
    I attempted giving the name of the sheet like you showed, but it still does not work. If I gave you the whole script, do you think it might help?

    Thanks,
    ~Vanessa~
[reply]
      Email it to me: jmoosmann@earthlink.com
      I honestly can't look at it until I get off of work though.

      JamesNC
[reply]
        OK. I just sent the code to your work e-mail.

        Thanks,
        ~Vanessa~
[reply]

In Section Seekers of Perl Wisdom