Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
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?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (10)
As of 2018-02-22 00:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    When it is dark outside I am happiest to see ...














    Results (288 votes). Check out past polls.

    Notices?