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

Filter the data in this loop

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

[download]
poj

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

    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]

      Just remove device from this line

      # $worksheet2->write(++$row2,$col2,substr($device,0,3).'-'.$bro);  
$worksheet2->write(++$row2,$col2,$bro);

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

        Thanks for your quick responses. Device keys are still coming with the Chart and this should be like below Browser1 Browser 2 Browser 3 Computer but its coming that not is required. Please check below Computer Browser1 Browser2 Browser3 Computer How I can remove that? but its required in the Chart table.

[reply]

In Section Seekers of Perl Wisdom