T O P I C R E V I E W |
IndiJones |
Posted - 10/05/2003 : 9:35:45 PM I have three columns in a worksheet. The 1st column represents Wavelength, W. The 2nd and 3rd columns represent calculated values, say A & B, at the corresponding wavelength. A & B are set as X and Y, respectively, for plotting a XY graph. The graph will exhibit the line connecting the respective points of A and B as usual and also exhibit the correspomding values of W on the line. The graph should plot each points of A & B but need not exhibit each points of W. The values of W will be shown at some set intervals. I need to do this for plotting a chromaticity chart.
Edited by - IndiJones on 10/05/2003 10:19:00 PM |
3 L A T E S T R E P L I E S (Newest First) |
Hideo Fujii |
Posted - 10/07/2003 : 5:53:10 PM Hi, It is unclear for me that when you highlight "only A and B and plot the graph", then why you were able to see "the markers of C" showing up... Maybe you can explain how you operated in more detail...
|
IndiJones |
Posted - 10/06/2003 : 10:49:06 PM Thanks for the advice! It worked but there's one problem. If I select only A and B and plot the graph, the markers of C shows up at the preset intervals but it doesn't show the values of C. If I select A,B and C and plot the graph, all the values of C shows up even if the interval is set at some other values. I would like to do the former one with the values of C showing up only at the marker points.
Edited by - IndiJones on 10/06/2003 11:08:50 PM |
Hideo Fujii |
Posted - 10/06/2003 : 10:20:16 AM If I correctly understand what you wrote, the following may work for you:
1) Make a column, say "C", after B, and copy W into C. 2) Set the designation of C to Label. 3) Run the following script from Script window: limit data1_c; kk=limit.size; skip=5; loop (ii,1,kk) {if(ii-int(ii/skip)*skip!=0) data1_c[ii]$=" ";} 4) Plot A(X),B(Y),C(L)
Does it work for you?
Edited by - Hideo Fujii on 10/06/2003 10:21:51 AM
Edited by - Hideo Fujii on 10/06/2003 10:23:03 AM
Edited by - Hideo Fujii on 10/06/2003 10:24:58 AM
Edited by - Hideo Fujii on 10/06/2003 10:25:27 AM |
|
|