Excel graph plot

[nkf]

Hi, i want to plot my test result with Excel, so i refer to the sample named Excel macro example.vi, but i realize that only 5 point can

be plotted on the chart, so anybody tell me how to plot all the point?

thanks

[mfitzsimons]

You can indeed plot more than 5 points.  Post your VI and I wll take a look at it.  Excel works fine so it has to be your VI.

Matt

[NIquist]

The reason only 5 (actually 6) points are plotted is because the Excel macro ('GraphData' in project.xls) is doing the plotting and its script tells it what to plot.  If you select Tools>Macros in the project.xls workbook you can open the script and edit it. 

Keep in mind LabVIEW is not plotting anything in Excel.  It is simply running a pre-existing excel macro.  If you need to plot in excel the easiest way is to use the chart wizard after you have moved your LabVIEW data to a spreadsheet.  Otherwise you'll have to learn to program macros in Microsofts Visual Basic.