Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: Help with Spreadsheet::WriteExcel::Chart

by tilly (Archbishop)
on Jan 24, 2011 at 06:35 UTC ( [id://883861]=note: print w/replies, xml ) Need Help??


in reply to Help with Spreadsheet::WriteExcel::Chart

Is it possible that what you think should be set by the name is instead being set by categories? What is x1_range_formula?

Replies are listed 'Best First'.
Re^2: Help with Spreadsheet::WriteExcel::Chart
by ag4ve (Monk) on Jan 24, 2011 at 12:19 UTC

    i suppose categories was my other question. i'm pretty sure i get what these functions are supposed to do and per the example here: http://search.cpan.org/dist/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel/Examples.pm#Example:_chart_stock.pl it should be possible to do what i want. i'm obviously just doing something wrong :) neither is being set to what i want. my spreadsheet looks like this

    x | date 1 | date 2 | date 3 | name | | | | data 1 | #### | #### | #### | data 2 | #### | #### | #### | data 3 | #### | #### | #### | | | | | name2 | | | | data 1 | #### | #### | #### | etc

    Spreadsheet::WriteExcel::Utility::xl_range_formula()

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://883861]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2024-03-29 01:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found