excel graph report

[gdah]

Hi there,

I need some help ...I  want to make an EXCEL report using report generation toolkit.I need to insert graph (pressure vs time) in the report. Can I set the x-axis scale? I have try Set Graph Scale.vi. It is only allowed me to set the y-axis scale...pls help...thanks

[BrianInTheForest]

Yes you can set the x-axis scale.

Place another Set Graph Scale.vi on the block diagram and instead of selecting xlValue select xlCategory.

[gdah]

when I change it to xlcategory there is error occured? is there any example that using the excel set graph scale.vi??

[BrianInTheForest]

I tried changing your graph type from xlLine to xlXYScatterLines but I still get the same error.

Error -2146827284 occurred at Exception occured in Microsoft Excel: OLEObjects method of Worksheet class failedHelp Path is C:\Program Files\Microsoft Office\Office10\1033\xlmain10.chm and context 0 in NI_ReportGenerationToolkit.lvlib:Excel_Set_Chart_Colors.vi->NI_Excel.lvclass:Excel Set Graph Colors.vi->graph%20report[1].vi

This error code is undefined. No one has provided a description for this code, or you might have wired a number that is not an error code to the error code input.

It took me a while to become efficient at using report generation toolkit especially the graph functions.

I have attached one of my routines that sets the scale of the x and y axis.

[bfeddeck]

Can you save this example as version 8.5?

[gdah]

Hi Brian,

I cannot open your vi.Can you save it as ver8.2 please..... thanks

[BrianInTheForest]

Here you go.