Questions and answers on how to use XLSReadWriteII 3/4/5.
-
Guest
- Posts: 83
- Joined: Tue Aug 16, 2005 6:08 pm
Post
by Guest »
If to set property "PieSliceDist" all pie's of the diagram become one color:
Code: Select all
with XLS.Sheets[0].AddChart do begin
Col1 := 5;
Col2 := 11;
Series[0].Values := '''1''!$A$2:$A$10';
Series[0].Category := '''1''!$B$2:$B$10';
PlotArea.ChartType := xctLine;
PlotArea.HasLegend := true;
PlotArea.Is3D := true;
PlotArea.ChartStyle.VaryColors := True;
Series[0].HasDefDataPoint := true;
Series[0].DefDataPoint.PieSliceDist := 10;
end;
-
larsa
- Site Admin
- Posts: 926
- Joined: Mon Jun 27, 2005 9:30 pm
Post
by larsa »
Hello
We will take a look at this. The chart handling will be improved when support for the new Excel file format is added to the component.
Lars Arvidsson