Anything you want with Excel is possible. Your choices include:
1. Use a template file that uses the INDIRECT function to extract data from another file
2. Use ActiveX to write data directly to a template file with the graphs
3. Use an Excel macro to create the graphs from the data
4. Copy and paste the data into a template file with the graphs
Your best bet is choice #1. Create a template with data on Sheet1 and your graphs on a separate
sheet. Then create formulas for the data array in sheet1 to find each data point in the other
file. A1 = INDIRECT("Datafile!A1"). You can then Define a Cell Name to "Datafile" and enter the
name of the file to display. When you change the name, the graphs updates instantly.
--
Michael Munroe Mailto:mmunroe@abcdefirm.
com
A Better Complete Development Engineering Firm
San Mateo, CA 94403 http://www.abcdefirm.com
"George M. Callara" wrote:
> Hello LabVIEW group,
>
> This is more of an excel question than a LabVIEW question, but I'm hoping
> one of you has run into this before. I'm saving array data going to an XY
> graph into an .xls file that has the correct deliminators to be read
> properly by MS Excel. This works very well for me because I can read this
> data and display it onto my XY graph later. However, when I open up excel,
> I have to go through the motions of selecting the proper rows and columns
> and graph wizards to re-create the graph in the excel program.
>
> Does anyone know of a way to use a template so that I don't have to do this.
> When I collect graph data, I collect dozens of graphs at a time and having
> to go into excel and re-create all these graphs is time consuming. Any info
> would be great.
>
> Thanks
>
> George Callara
>
> -----------== Posted via Newsfeeds.Co
m, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----
