Add a second y axis to a chart in excel

Select the data from the table


Go to Insert chart.Select 2D bars


You will observe that count bars will be hidden because of the scale which is automatically set to adjust the high values of timespent.Therefore select red bars and change their style to line by



Change series chart type to Line


Go to layout (keep the line chart of timespent selected),Select Format selection and choose secondary axis



 Now the data will look like this


So you have two y axes corresponding to the same X axis data.Hope it helps you in analysing data.:)