Hello and thanks for any advice. I’ve simplified my scenario as below. A teacher and student have a walking contest over 7 days. Column A is date, Column B is role (i.e. teacher or student), Column C is miles walked. I would like to create a line chart with 2 data series comparing the teacher’s walking to the student’s walking. 

Ideally, when selecting the data for each series, I could input a formula filtering Column B for either “teacher” or “student” and then plotting the associated ‘miles walked’, I’ve included a sample data set.

 RoleMiles walked1/1/2001Teacher11/1/2001Student21/2/2001Teacher51/2/2001Student41/3/2001Teacher21/3/2001Student11/4/2001Teacher31/4/2001Student41/5/2001Teacher51/5/2001Student11/6/2001Teacher21/6/2001Student31/7/2001Teacher51/7/2001Student1

​Hello and thanks for any advice. I’ve simplified my scenario as below. A teacher and student have a walking contest over 7 days. Column A is date, Column B is role (i.e. teacher or student), Column C is miles walked. I would like to create a line chart with 2 data series comparing the teacher’s walking to the student’s walking.  Ideally, when selecting the data for each series, I could input a formula filtering Column B for either “teacher” or “student” and then plotting the associated ‘miles walked’, I’ve included a sample data set.  RoleMiles walked1/1/2001Teacher11/1/2001Student21/2/2001Teacher51/2/2001Student41/3/2001Teacher21/3/2001Student11/4/2001Teacher31/4/2001Student41/5/2001Teacher51/5/2001Student11/6/2001Teacher21/6/2001Student31/7/2001Teacher51/7/2001Student1  Read More

​