Re^4: 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]

Comment on Re^4: Unable to create a Pivot chart with visiable Columns Download Code

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]
Re^6: Unable to create a Pivot chart with visiable Columns by chandantul (Scribe) on Sep 10, 2018 at 21:09 UTC
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]
Re^7: Unable to create a Pivot chart with visiable Columns by poj (Abbot) on Sep 11, 2018 at 12:36 UTC
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]
Re^8: Unable to create a Pivot chart with visiable Columns by chandantul (Scribe) on Sep 11, 2018 at 16:31 UTC
Re^9: Unable to create a Pivot chart with visiable Columns by chandantul (Scribe) on Sep 11, 2018 at 20:21 UTC
Some notes below your chosen depth have not been shown here


Come for the quick hacks, stay for the epiphanies.
	PerlMonks