I am trying to create charts for a program I am making. I create an instance of excel, create 4 worksheets(1 for each unit I am testing) within a single workbook. I write data to each sheet based on which unit I am reading. After the program reaches it end I attempt to create graphs. I create an empty chart and use the chartwizard to format and create the graphs. There are instances when I test less than 4 units and for the sheets that have no unit the graph formatting working fine, but for the sheets that actually have data saved the chart is not formatted at all. Below is my code for creating the graphs.
char ChartRange[100000];
sprintf(ChartRange, "A1:L%d", writeline);
/// REGION START Create Graphs
/// REGION START UUT1
ExcelRpt_SetCellRangeAttribute(UUT1, "A:A", ER_CR_ATTR_NUMBER_FORMAT, "m/d/yyyy h:mm:ss");
FmtOut("# ");
Delay(1);
ExcelRpt_ChartAddtoWorksheet(UUT1,650,1,750,500,&UUT1chart);
FmtOut("# ");
Delay(1);
ExcelRpt_SetChartAttribute(UUT1chart, ER_CH_ATTR_LEGEND_POSITION,-4107);
FmtOut("# ");
Delay(1);
ExcelRpt_SetChartAttribute(UUT1chart, ER_CH_ATTR_CHART_SIZE_WITH_WINDOW,1);
FmtOut("# ");
Delay(1);
ExcelRpt_ChartWizard(UUT1chart,UUT1,ChartRange,ExRConst_XYScatterLinesNoMarkers,0,0,1,1,1,SerNo[0],NULL,NULL,NULL);
FmtOut("# ");
/// REGION END
NOTE: the delays were an attempt to give CVI time to format everything properly.
NOTE: if I put a break point on the ChartWizard line the graph is made fine.
