Axis scaling in labwindows for excel graph

[jlenoach]

I'm plotting an excel scatter graph onto my user interface with activeX controls. I have tried to use the SetChartAxisAttribute function from Excel Report to set the minimum values on the graph and specify the exact type of graph that I want, but the function does not seem to work. Does anyone know why this is happening?

[Ben M]

Hello jlenoach,

Thank you for contacting National Instruments. I do not have an answer for this issue yet but I will update the post as soon as I find out more about how to approach the problem.

[Ben M]

Hello jlenoach,

I have been unable to duplicate the problem.  Can you please post your code or enough of your code to duplicate the problem?

[jlenoach]

Ive tried it a bunch of different ways, but here is what I have right now

ExcelRpt_GetWorksheetFromIndex(workbookHandle,1,&rawDataWorkSheetHandle);
ExcelRpt_SetWorksheetAttribute(rawDataWorkSheetHandle,ER_WS_ATTR_NAME,"Analysis Data");
ExcelRpt_WriteDataFromTableControl (rawDataWorkSheetHandle, location,
                                            panelHandle2, PANEL2_TABLE);
           
ExcelRpt_ChartAddtoWorksheet (rawDataWorkSheetHandle, 0, 0,
                                                   7.0*69, 4.0*74, &chartHandle);
           
ExcelRpt_SetChartAttribute (chartHandle,ER_CH_ATTR_CHART_SIZE_WITH_WINDOW,0);
           
location = "A2:K42";   
               
ExcelRpt_ChartWizard (chartHandle, rawDataWorkSheetHandle, location, ExRConst_GalleryXYScatter,
                                          ExRConst_Columns, 0, 0, 0, 1, "Data", "Z position", "Hall Probe", NULL);
   
ExcelRpt_SetChartAxisAttribute (chartHandle, ExRConst_Value,
                                            ExRConst_Primary,
                                            ER_CH_ATTR_MINIMUM_SCALE_IS_AUTO,
                                            ExRConst_False);
                                         
ExcelRpt_SetChartAxisAttribute (chartHandle, ExRConst_Value,
                                                          ExRConst_Primary,
                                                          ER_CH_ATTR_MINIMUM_SCALE,
                                                          100);
           
ExcelRpt_ChartSetSourceRange (chartHandle, rawDataWorkSheetHandle,
                                          location);

[Ben M]

Hello jlenoach,

I am still unable to duplicate the same behaviour that you are describing.  I have attached a working example which uses the same functions to successfully accomplish updates to a chart in excel.  Please let me know if you have any other questions.

[blinde2000]

Hi.

I am facing a similar issue.

I have tested the attached peace of code.

It works fine to set the min on Y Axis.

What should I do to make the same thing on X Axis ?

Tried to replace ExRConst_Primary by ExRConst_Secondary ... But it fails...

Working under CVI 8.5.

Thanks

[RobertoBozzolo]

Not sure about that but ExRConst_Secondary refers probably to the secondary Y-axis (the one shown on the right of the graph).

You will probably have success by setting Axis type parameter to ExRConst_Category.

I cannot test at the moment as I don't have Excel installed on this machine.

[blinde2000]

Thanks, works fine

Chris