Question

How do I make the series graph

Answer 1

Creating a Time Series Plot

A time series of USGS stream flow records for a station is shown below in an Excel sheet. To create a time series plot, both the time stamp and data value are needed. The time stamp associated with data is stored in one column in Excel, and corresponding data values are stored in another column as shown below (Column C has time stamp and column D has stream flow values in cfs).

To create a time series plot in Excel, first select the time (DateTime in this case) Column and then the data series (streamflow in this case) column. Next, click on the Insert ribbon, and then select Scatter. From scatter plot options, select Scatter with Smooth Lines as shown below.

A time series plot of streamflow will be created as shown below.

The legend, title and axes of this plot can then be reformatted to make the time series plot look a little more legible and professional as shown below.

Long-term streamflow data as shown above and streamflow hydrographs for individual events are typically presented by using smooth scatter plots. Precipitation data are typically represented by using column plots.

OK, you are done creating a time series plot. Save your excel file.