charts problems (Help)

[Guest]

Hi~

I have some problems while using XLSReadWriteII30's charts.

1. When there are two serieses, I modify each series property , but only have the first series valid, other invalid

code:
for(int nSeries = 0 ; nSeries < 2 ; nSeries ++)
{
XLSReadWriteII21->Sheet[0]->Charts->Items[0]->Series->Items[nSeries]->Values = newValue;
}

2. I set the "options" value of the "ValueAxisScaling" concerning "valueaxis" in the "plotarea" to "vasoLogScale" , but it is invalid.

code:
XLSReadWriteII21->Sheet[0]->Charts->Items[0]->PlotArea ->ValueAxis->ValueAxisScaling ->Options = vasoLogScale;

3. How to set the property of "XValueaxis" in the "plotarea", such as "MaxValue", "MinValue" etc ?

4. How to modify the "backgroundcolor" and "foregroundcolor" in "TMarketFomat" class , if I want to set "no color" property ?

Please help to solve these problems , thanks.

[larsa]

Hello

1. I don't have any problems with this. Please note that the cell referense must be absolute, such as: Sheet1!$A$3:$A$14

2. The Options type is a (delphi) set. I don't know how to write this in C++.

3. I can't find the XValueaxis property.


Lars Arvidsson