in reply to Re^13: Unable to create a Pivot chart with visiable Columns
in thread Unable to create a Pivot chart with visiable Columns

Just add the code before the $workbook->close. Adjust the row, col, width values to suit your data.

$row2    = 44;
$col2     = 4;
my $width = 4;
for my $device (@device){
  my $text = $workbook1->add_shape( type => 'rect', text => $device, l
+ine=>1 );
  $worksheet2->insert_shape( $row2, $col2, $text );
  $col2 += $width;
}
$workbook1->close();

[download]
poj

Replies are listed 'Best First'.
Re^15: Unable to create a Pivot chart with visiable Columns
by chandantul (Scribe) on Sep 12, 2018 at 16:15 UTC

    Thanks a lot Sir! This is working! but I have one more question how I can exclude IEE7 Browser ( Specific ) from the list? I need to filter the same.

[reply]

      Filter the data in this loop

      for ($k = 0; $k <= $#responseid; $k++)  {
   next if ($responseclientbrowser[$k] =~ /IEE7/i);

      [download]
      poj
[reply]
[d/l]

        Great Master!!! I have learnt a lot from you. One more thing. How I can drop device information on the same row with Browser in the chart now? I am trying but its messing up?

[reply]

In Section Seekers of Perl Wisdom