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")};
In Section
Seekers of Perl Wisdom