I am trying to create a chart for real estate showing the length of a task
vs the final results.

There are three variables representing each trial:

Group ID
Duration
Results

For each group there is a variable number of trials.

It was a simple task to use a pivot table to create a bar graph of the
average duration for each group, sorted in ascending order, and the pivot
table included the average results in the table as well.

What I want to end up with is a bar graph with the group IDs on the X axis,
sorted by the average duration, charted on the Y axis. To this graph I want
to add a line graph with the average results, also plotted on the Y axis.

What is the best way to accomplish this?

Thank you