ChartWizard difference between Excel 2003 and 2007
 

Hello

I have a some automation code written in mfc c++ that creates a chart in an
excel sheet that I create that works fine in excel 2003, but not in excel
2007. It generates an exception.

Error Codes :

tCode = 80070057
Code meaning = The parameter is incorrect
tSource = S
tDescription = This object has no title.

Piece of C++ code :

RangePtr pBrHRange = pBRSheet-Range["Q10:S34"][vtMissing];
_ChartPtr pBrHChart = pBook-Charts-Add();

pBrHChart-ChartWizard((Range*) pBrHRange, (long) xl3DColumn, vtMissing,
(long) xlColumns, 1, 1, 0, "Bright Field Size Chart", "Cell Size (microns)",
"Number of Cells" );

pBrHChart-Name = "Bright Field Size Chart";

The exception is blows on pBrHChart-ChartWizard() with excel 2007, but runs
fine and correctly creates the chart with Excel 2003. If I change
pBRSheet-Range["Q10:S34"][vtMissing]; to
pBRSheet-Range["Q10:R34"][vtMissing]; it works fine, but does not display
the correct chart.

Sample Data in the Q,R,S columns
2.05 2 0
2.37 0 0
2.70 6 0
3.03 0 0
3.36 0 0
3.68 91 0
4.01 0 0
4.34 0 0
4.66 0 1
4.99 0 0
5.32 3 3
5.65 3 0
5.97 0 0
6.30 1 0
6.63 0 0
6.96 0 0
7.28 0 0
7.61 0 0
7.94 1 0
8.26 0 0
8.59 0 0
8.92 0 0
9.25 0 0
9.57 0 0
9.90 0 1

Any clues to what has changed and how to work arround it would be
appreciated. Thanks.

Kevin