Hello Team, I have been trying to show the Column chart by linking one sheet on the same file but I was unable to add 2 columns categories under single legend. I need your help to fix this issue. Please check my Code snippet below
$workbook1 = Excel::Writer::XLSX->new($strExcelFilename);
#$worksheet1 = $workbook1->addworksheet("DEVICE-BROWSER-LIST")
+;
$worksheet1 = $workbook1->add_worksheet('Data');
$worksheet2 = $workbook1->add_worksheet('Summary');
$row1= 1;
foreach $worksheet1 ($workbook1->sheets()) {
if( $worksheet1->get_name() eq $SUCCESS_COUNT_SHEET_NAME ) {
$format = $workbook1->add_format(%header);
$worksheet1->write(0,0, "User Id", $format);
$worksheet1->write(0,1, "User Display Name", $format);
$worksheet1->write(0,2, "User Email Id", $format);
$worksheet1->write(0,3, "Device", $format);
$worksheet1->write(0,4, "Browser", $format);
$worksheet1->write(0,5,"Application Name", $format);
$worksheet1->write(0,6,"TimeStamp", $format);
#$worksheet1->write(0,7, "EMAIL--ITUSER-STATUS", $format);
for ($k = 0; $k <= $#responseid; $k++) {
$worksheet1->write($row1,0, $responseid[$k]);
$worksheet1->write($row1,1, $responsdisp[$k]);
$worksheet1->write($row1,2, $responsalter[$k]);
$worksheet1->write($row1,3, $responseclientdevice[$k]);
$worksheet1->write($row1,4, $responseclientbrowser[$k]);
$worksheet1->write($row1,5, $responseapps5[$k]);
$worksheet1->write($row1,6, $estdate[$k]);
$row1++;
}
}
$chart1 = $workbook1->add_chart( type => 'column', embedded => 1
+ );
$chart1->add_series(
categories => '='. "Data" . '!$E$2:$E$1200',
name => '='."Data".'!$F$1',
values => '='."Data".'!$F$2:$F$1200',
);
$chart1->add_series(
categories => '='. "Data" . '!$D$2:$E$1200',
values => '='."Data".'!$D$2:$D$1200',
);
$chart1->set_title ( name => 'Results of sample analysis
+' );
$chart1->set_x_axis( name => 'Computer' );
$chart1->set_y_axis( name => 'Browser' );
$chart1->set_style( 11 );
$worksheet2->insert_chart( 'E2', $chart1, 25, 10 );
}
$workbook1->close();