in reply to Re^2: Excel and Win32::OLE chart problems
in thread Excel and Win32::OLE chart problems
If I understand your question correctly, the values in B5-B12 should be the XAxis labels, right?
If so, use that range as the source data for the chart, ie
instead of just D5:D12. I believe that the two SeriesCollection lines are the defaults, so they shouldn't be necessary. Keep the ColorIndex line though.$chart->Chart->ChartWizard({Source => $sheet->Range("B5:B12,D5:D12")};
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^4: Excel and Win32::OLE chart problems
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