omitted, watershed associations and other water advocates can see the areas where they can most effectively assist or best request assistance from governmental agencies. By identifying the specific sampling sites that have a consistent measurement, it makes filtering the data in Data Main’ simpler so that graphs of trends over time for ‘Lab various measurement types can be produced. Identify the sample site you are interested in looking at using the Pivot table Go to Lab Data Main page Use tool on the Column to filter data such that only data from ‘Filter’ “STAID_YR” the station in question is shown Do the same in Column to filter data such that only data for the “DWN_Name” specific measurement type is shown Copy the following columns into a new sheet: Datayear, UNIQUE_ID, DWM_NAME, DWM_Units, ResVal, and StartDate. Use the sort toll on the column in the new page to verify that the “StartDate” data is listed in chronological order Insert a scatterplot, and select data such that is on the y axis and “ResVal” is on the x axis. “StartDate” Format the chart as desired, add trend lines and more.
omitted, watershed associations and other water advocates can see the areas where they can most effectively assist or best request assistance from governmental agencies. By identifying the specific sampling sites that have a consistent measurement, it makes filtering the data in ‘Lab Data Main’ simpler so that graphs of trends over time for various measurement types can be produced. Identify the sample site you are interested in looking at using the Pivot table Go to Lab Data Main page Use ‘Filter’ tool on the “STAID_YR” Column to filter data such that only data from the station in question is shown Do the same in “DWN_Name” Column to filter data such that only data for the specific measurement type is shown Copy the following columns into a new sheet: Datayear, UNIQUE_ID, DWM_NAME, DWM_Units, ResVal, and StartDate. Use the sort toll on the column “StartDate” in the new page to verify that the data is listed in chronological order Insert a scatterplot, and select data such that “ResVal” is on the y axis and “StartDate” is on the x axis. Format the chart as desired, add trend lines and more.