Time series plots and scatterplots can be used with a secondary axis. Here, we will use the Oxford weather station's data to plot the temperature and hours of sunlight on the same chart. Temperature will be displayed on the left y axis; Sun(Hours) will be displayed on the right axis.
As done in the previous recipe, we will use the Oxford weather station's data. See the details in the Creating a time series plot recipe. Most of the steps in this example will be similar to the time series plot instructions, except the use of the multiple time series plots instead of a single one.
Let's get started with the steps that would help us add a secondary axis to a time series plot:
Go to the Graph menu and select Time Series Plot….
Select the Multiple chart.
Enter the column for mean maximum temperature and the column for hours of sunlight into the section labeled Series:.
Follow the steps in the previous example to add the year and...