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

Thanks a lot Man!! I wanted to show like for all applications and the Computer , Mobile and other devices should be isolated from Browser names. Can we add this below in the Chart itself above Device/Browser but below browser's names in X axes? Grand Total 2 1 195 72 5 45 59 12 370 6 19 514 3 1303 Do I need to add the total count like below? Can you please help?

 for (sort keys %count){
  $sheet2->write_row($row++,0,[$_,$count{$_}]);
}

[download]

Replies are listed 'Best First'.
Re^5: Unable to create a Pivot chart with visiable Columns
by poj (Abbot) on Sep 10, 2018 at 20:51 UTC

    I'm sorry I don't understand your requirement. Do you mean adding a line on the chart like this ?

    
 5 |      y
 4 |  y   y  x            x app1
 3 |  y  xy  x        y   y app2
 2 |  yz xy  xy   y   yz  z app3
 1 | xyz xyz xyz xyz xyz
   ------------------------------
     com lap tab br1 br2 
      insert line here ?
         Device/Browser
    poj
[reply]

      Thanks for your responses! As per your example, com lap tab br1 br2 should be showing as browsers. The sections for different devices will be looking like below and just above Chart in Chart Table at last line after counts there would be total counts of hits for different applications by different browsers as GRAND TOTAL without breaking earlier codes . Like below. Grand Total 5 | y 4 | y y x x app1 3 | y xy x y y app2 2 | yz xy xy y yz z app3 1 | xyz xyz xyz xyz xyz -------------------------------------------------------------------- br1 br2 br3 br4 etc br1 br2 br3 br4 etc br1 br2 br3 br4 etc Computer Tablet Mobile Device/Browser

[reply]
        Grand Total

 5 |      y
 4 |  y   y  x            x app1
 3 |  y  xy  x        y   y app2
 2 |  yz xy  xy   y   yz  z app3
 1 | xyz xyz xyz xyz xyz
   --------------------------------------------------------------------
     br1 br2 br3 br4 etc   br1 br2 br3 br4 etc     br1 br2 br3 br4 etc 
      Computer                   Tablet                  Mobile
                            Device/Browser

        I suggest you create a separate graph for each device.

        poj
[reply]

In Section Seekers of Perl Wisdom