Automatic chart display after logging the data's in excel using write to measurement file or write to data file

[dineshniot]

Hi - Is there any possibility to automatically display the chart for the logged datas using write to measurement file or write to data file? Please let me know as soon as possible.

Thanks and Regards,

Dinesh

[RavensFan]

What do you mean by "automatically display the chart"?

If you want to put data in a chart, write your program to do that.

[dineshniot]

Thanks for your reply , I want to display the chart in excel sheet automatically after logging the data's using write to spreadsheet file , it means, when I Open the logged excel sheet , ti should come with logged data's along with chart display in it.

I don't know how to program the same. Can you please guide me on this. Please do the needful.

Regards

Dinesh

[RavensFan]

This is a different question.  You didn't mention Excel in your first message.  (Actually, I now see you had the word "Excel" in the subject line.)

You do know that Write to Measurement file doesn't create an Excel file?  It creates a text file that Excel is able to import.

What you need to do is work with Excel more directly.  Use ActiveX calls to create a real .xls Excel Spreadsheet File.  Place the data into the worksheet, and then use other ActiveX methods and properties to create the chart and link it to your newly placed data.  Look in the example finder for VI's that demonstrate how to use ActiveX calls with Excel.

[billko]

---

@dineshniot wrote:

Hi - Is there any possibility to automatically display the chart for the logged datas using write to measurement file or write to data file? Please let me know as soon as possible.

Thanks and Regards,

Dinesh

---

As an aside, "data" is already a plural.  The singular is "datum."