In my Case D is the Device data but having more than 1200 rows and E is Browser data having more than 1200 rows. Please check below code snippet. and suggest if this can be appropriate in my Case?
my $chart = $workbook1->add_chart( type => 'column', embedded => 1 );
$chart->set_size( width => 1000, height => 500 );
#my $col = 'B';
$col2 = 0;
for my $app (sort keys %app){
++$col2;
# $chart->add_series(
# name => $app,
# categories => ['Summary',1,$row2,0,0],
# values => ['Summary',1,$row2,$col2,$col2]
# );
$chart->add_series(
categories => '=(Data!$D$1:$D$9,Data!$D$14:$D$25)',
values => '=(Data!$E$1:$E$9,Data!$E$14:$E$25)',
);
}
$chart->set_title ( name => 'Results of sample analysis' );
$chart->set_x_axis( name => 'Device/Browser' );
$chart->set_y_axis( name => 'User Count' );
# add chart
$worksheet2->insert_chart( 26, 1 , $chart);
$row2 = 48;
$col2 = 4;
my $width = 3;
for my $device (@device){
my $text = $workbook1->add_shape( type => 'rect', text => $device, l
+ine=>1, bold => 1 );
$worksheet2->insert_shape( $row2, $col2, $text );
$col2 += $width;
}
$workbook1->close();
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.