Hi, Your data is not on a grid, but you can use PLOT/VS to make plots of it. First, save the file as type .csv. Then, I see that missing data is represented by ND. I would suggest editing your file and changing ND to a numeric value, say -9999. Then you tell Ferret that this is the missing-value flag for the data.yes? columns/skip=1/var="lat,lon,depth,collection,np,ns,sp" filename.csv On 8/28/2017 2:51 AM, Karnan C wrote:
Dear ferret_users, I don't get any idea to define my data and plot it properly. Here I have attached one set of data (Ratios.xlsx) and the expected to plot a time series vertical section plot (similar to attached image; plotodv.png). I don't have enough knowledge on irregular data plot from xls format. Please someone help me, Thank you. My data looks like, Latitude Longitude Depth Collection NP NS SP 9.4915 76.3140 0 1 0.196 0.007 27.216 9.4915 76.3140 1 1 0.170 0.007 23.283 9.4915 76.3140 2 1 0.232 0.010 22.161 9.4915 76.3140 3 1 0.877 0.044 19.877 9.4915 76.3140 4 1 1.163 0.048 24.070 9.4915 76.3140 5 1 2.621 0.168 15.603 9.4915 76.3140 0 2 0.226 0.006 35.194 9.4915 76.3140 1 2 1.711 0.049 34.921 9.4915 76.3140 2 2 0.171 0.005 31.857 9.4915 76.3140 3 2 2.585 0.071 36.463 9.4915 76.3140 4 2 5.291 0.193 27.364 9.4915 76.3140 5 2 5.987 0.226 26.493 9.4915 76.3140 0 3 ND ND 24.735 9.4915 76.3140 2 3 0.300 0.012 24.588 9.4915 76.3140 4 3 0.356 0.023 15.620 9.4915 76.3140 6 3 1.606 0.242 6.640 9.4915 76.3140 0 4 3.913 0.087 44.864 9.4915 76.3140 2 4 5.093 0.147 34.744 9.4915 76.3140 4 4 2.608 0.089 29.463 9.4915 76.3140 6 4 1.655 0.086 19.165 9.4915 76.3140 0 5 0.160 0.016 9.915 9.4915 76.3140 2 5 1.250 0.077 16.281 ======================================================================= Thanks you. Regards, Karnan C. ====================================== 2017-08-25 11:17 GMT+05:30, Ryo Furue <furue@xxxxxxxxxx>:Hi Karnan, I have to generate a time series vertical plot of nutrient or any data.In which I need y=depth and x=collection dates/numbers. My delimited data set contains 5 columns such as depth, collection, data1, data2, data3. My collection is regular from 1 to 18 but the depths of each collection were irregular. I have tried with some earlier queries and methods. I can define time axis (regular), but I can't find a solution for depth (irregular).I haven't looked at details of your data, but here is a snipped of the code to plot a depth-distance distribution of oxygen by regridding the the irregular depths to a regular grid: define axis/z=0:6000:100/depth/units="meters" depax ! New depth axis define axis/x . . . . horax define grid/x=horax/z=depax mygrid FILE/VAR="station,depth,oxygen"/GRID=mygrid/order=ZX oxygen.dat let oxy = ZAXREPLACE(oxygen, depth, z[gz=depax]) The trick is ZAXREPLACE . See the Ferret manual. Hope this helps, Ryo |