Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re^3: OLE - updating a chart in an excel spreadsheet

by Anonymous Monk
on Oct 13, 2012 at 00:33 UTC ( #998805=note: print w/replies, xml ) Need Help??


in reply to Re: Re: OLE - updating a chart in an excel spreadsheet
in thread OLE - updating a chart in an excel spreadsheet

This works for me

my $Chart1Range = $DataSheet->Range("A1:A295,G1:G295"); $Chart1->SetSourceData($Chart1Range,xlColumns);

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://998805]
help
Chatterbox?
[GotToBTru]: late to the conversation .. but thanks, Corion, for the reminder about Perl::Tidy
[Corion]: GotToBTru: Heh ;) I'm not really endorsing it, as I found that any gains made through it are easily squandered by the hours spent on configuring it. At least in my case :)
[GotToBTru]: Like most Swiss Army Knives, you can cut yourself trying to find the blade you actually want

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (11)
As of 2017-02-27 14:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (387 votes). Check out past polls.