The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 How to fill legend with info in line#1
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

rainer21

Germany
1 Posts

Posted - 05/12/2002 :  06:06:04 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello!

Maybe you could help me:

In the first row of my table there are the names
of the columns which I want to use in the legend

Example:

A(X) B(Y) C(Y) D(Y)
1 Voltage/U A1 A2 B1
2 0 0,045 0,043 0,062
3 1 0,076 0,072 0,092
4 2 0,152 0,150 0,205
....


Every table has about 50 columns and it would be
annoying to write A1, A2, B1, B2 etc. into the
legend by hand for every table.

How can I format "\L(1) %(1)" ect. to get the text from
the first line (A1, A2, B1,...) into the legend?


..In M$ Ecxel this is done automatically
but I do not want to use it because it
is not good enough for scientific analysis.

Thanks in advance
Rainer

cpyang

USA
1406 Posts

Posted - 05/12/2002 :  2:18:53 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
If you are using Origin 5.0 or later, and open an Excel workbook with such data in Origin(File:Open Excel), and you select the data and plot, you get exactly what you are looking for.

If you import such data into Origin, the 1st row will also imported automatically as column label and when you plot, they also automatically appear in legend.

You can always write a simple script to take 1st row of each column and put them into column labels and when plotted, they will go into legend as well.

CP


Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000