in reply to Re: Excel and Win32::OLE chart problems
in thread Excel and Win32::OLE chart problems
Thanks!
That fix the "style" of the graph!
Unfortunately, I still didn't get the XAxis Values.
Did you still get enough time to help me again?
Here's my *new* code
Thanks again!# Create the chart # $chart = $sheet->ChartObjects->Add(1, 175, 457, 300); $chart->Chart->{ChartType} = xl3DColumnClustered; $chart->Chart->ChartWizard({Source =>$sheet->Range("D5:D12")}); $chart->Chart->SeriesCollection(1)->{XValues}=$sheet->Range("D5:D12"); $chart->Chart->SeriesCollection(1)->{HasDataLabels} = 1; $chart->Chart->SeriesCollection(1)->Interior->{ColorIndex} = 36; $chart->Chart->{HasLegend} = $vtfalse; $chart->Chart->{HasDataTable} = $vtfalse; with ($chart->Chart, 'Elevation' => 15, 'Perspective' => 0, 'Rotation' => 20, 'RightAngleAxes' => $vttrue, 'HeightPercent' => 100, 'AutoScaling' => $vttrue); with ($chart->Chart->Axes(xlCategory), 'TickLabelSpacing' => 1, 'TickMarkSpacing' => 1);
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Excel and Win32::OLE chart problems
by bmann (Priest) on Oct 30, 2007 at 20:08 UTC | |
by the_hawk_1 (Scribe) on Oct 30, 2007 at 21:36 UTC | |
by lvleph (Initiate) on Jul 18, 2008 at 20:13 UTC | |
by Anonymous Monk on Sep 07, 2009 at 11:21 UTC | |
by Anonymous Monk on Sep 08, 2009 at 06:49 UTC |
In Section
Seekers of Perl Wisdom