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 > -- C. Karnan, CSIR - SRF Ph. D Research Scholar National Institute of Oceanography (CSIR) Regional Centre, Dr Salim Ali Road Kochi - 682 018. India. Mobile No. +91 9633032345; +91 9941811608
Attachment:
plotodv.png
Description: PNG image
Attachment:
Ratios.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
