Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

line colors in Spreadsheet::WriteExcel

by temporal (Pilgrim)
on May 31, 2012 at 16:52 UTC ( #973559=perlquestion: print w/ replies, xml ) Need Help??
temporal has asked for the wisdom of the Perl Monks concerning the following question:

Silly question for this old-ish module. I've got some line charts that are generated using Spreadsheet::WriteExcel. I'd like to change the color of the lines from the default to something else. Seems simple enough.

Has anyone stumbled upon a way to accomplish this? The documentation doesn't include this functionality and I'm beginning to suspect that it hasn't been implemented.

Strange things are afoot at the Circle-K.

Comment on line colors in Spreadsheet::WriteExcel
Re: line colors in Spreadsheet::WriteExcel
by roboticus (Canon) on May 31, 2012 at 18:09 UTC

    temporal:

    You may be right. I didn't see any likely candidates in the examples directory, and the t (tests) directory didn't show me anything obvious, either. You may want to look more closely at the tests 62_chart_formats.t and 63_chart_area_formats.t more closely than I did, as you might find a hint there. (Both mention colors, but I didn't see anything on changing line colors.)

    ...roboticus

    When your only tool is a hammer, all problems look like your thumb.

      Thanks for digging around roboticus =)

      It hadn't occurred to me to check the tests (usually I dive straight into laborious source-mining). Took a close look at them and this functionality isn't being tested so I'm going to assume it doesn't exist.

      Strange things are afoot at the Circle-K.

Re: line colors in Spreadsheet::WriteExcel
by jmcnamara (Monsignor) on Jun 02, 2012 at 13:39 UTC

    Changing the line colour in charts isn't possible in Spreadsheet::WriteExcel.

    It is possible with Excel::Writer::XLSX which is an API compatible replacement for Spreadsheet::WriteExcel.

    --
    John.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://973559]
Approved by ww
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (10)
As of 2014-09-22 12:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (191 votes), past polls