Setting Chart MarkerStyle and file error

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
BobM
Posts: 5
Joined: Sat Jun 30, 2007 2:29 am

Setting Chart MarkerStyle and file error

Post by BobM »

I'm trying to set the marker style of a series like so:

vSeries := Series[0];
with vSeries do begin
HasDefDataPoint := TRUE;
DefDataPoint.MarkerFormat.Automatic := FALSE;
DefDataPoint.MarkerFormat.Size := 20;
DefDataPoint.AreaFormat.ForegroundColor := xcYellow;
end;

If I do this, save the workbook, then open it, Excel throws an error: "File error: data may have been lost.". The workbook then opens, but the series referenced above has a marker size of 2pts, and black fore/background.

What is the proper way of setting the marker size?

thanks,

Bob M.
Post Reply