how to plot extensive list of variables in excel using perl -
i trying plot more 100 variables on x-axis in excel using perl. although code works fine not x-axis variables listed in graph alternates.
please me in if can plot required x-axis points on graph. following code excerpt:
my $chart = $workbookphase2->add_chart(type => 'column', embedded => 1); # configure chart. $chart->add_series( categories => '=pnc!$c$2:$c$100', values => '=pnc!$h$2:$h$100', ); $chart->set_x_axis(num_font => { bold => 1, italic => 1 }); # insert chart worksheet (with offset). $worksheetphase2->insert_chart('c4', $chart, 55, 14);
thanks!
Comments
Post a Comment