Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Display 2nd Y-axis in Spreadsheet::WriteExcel

by tc_blr (Novice)
on Apr 02, 2013 at 09:40 UTC ( #1026637=perlquestion: print w/ replies, xml ) Need Help??
tc_blr has asked for the wisdom of the Perl Monks concerning the following question:

Hi, i have a chart with two series' for the y axis. i am using Spreadsheet::WriteExcel to create these charts. Is it possible that I could display the data and name for the 2nd Y-axis as well? If yes, How? Please suggest... i tried the following but it is not working because the value of hash key name is being overwritten in the later part of the below given code. Code:-
# #some more code # $chartsheet=$workbook2->add_worksheet('Chart'); $chart=$workbook2->add_chart(type=>'line', embedded=>1); $chart->set_plotarea(weight=>'none'); $chart->add_series( categories=>xl_range_formula('series1',1,$row_max,1,1), values=>xl_range_formula('series1',1,$row_max,3,3), name=>'series1' ); $chart->set_y_axis(name=>'Y-axis1'); $chart->add_series( categories=>xl_range_formula('series2',1,$row_max,1,1), values=>xl_range_formula('series2',1,$row_max,5,5), name=>'series2' ); $chart->set_y_axis(name=>'Y-axis2'); $chart->set_x_axis(name=>'X-axis'); $chartsheet->insert_chart(0,0,$chart,0,0,1,1);
Is there any workaround to this?

Comment on Display 2nd Y-axis in Spreadsheet::WriteExcel
Select or Download Code
Replies are listed 'Best First'.
Re: Display 2nd Y-axis in Spreadsheet::WriteExcel
by Anonymous Monk on Apr 02, 2013 at 13:33 UTC

    That isn't possible with Spreadsheet::WriteExcel.

    However, it is possible with Excel::Writer::XLSX: Example.

      Got it...Thanks for ur response...!

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (12)
As of 2015-07-31 14:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (278 votes), past polls