12 Replies Latest reply: Oct 3, 2007 12:00 AM by ptc-1368288 RSS

    Plotting Hydrology Daily Discharge Data from Excel

      Class: Intro to Physical Hydrology

      I am trying to plot daily discharge data (for a tributary river into the Rio Grande River) versus time from a MS Excel 2000 worksheet. I imported the data from a class web page and did the necessary unit conversions in Excel. Now, I need to plot daily discharge versus time for the entire record...from 1932 to present.

      As you can imagine there are several thousand data points involved, the cell range is from G3 to G27367, and the corresponding dates for each data point range from cell H3 to H27367. I prefer to plot this data using MathCAD 11 instead of MS Excel 2000, but at this point I am open to suggestions. How can I import the data from MS Excel into MathCAD 11 and do the plot for the entire record period???