I think the graphs you are showing as an example have been made on PrismGraph which in my opinion is a great program.
To do this in excel (as far as I know) you need to "trick" the program a bit, but is doable. You need to draw a Scatter plot, basically an XY graph without lines. Plot your data in different columns by treatment, and each patient data in one row (for each corresponding column). Select all your data and insert Scatter plot, the first options (just dots). You then have to select "design" and swith row/column for it to look like you want. Finally, to get your mean or median plotted you need to calculate this on excel (average or median respectively) and then edit that data series and make it look like a line rather than a dot. Also, you can edit all your data points if you'd like to, so they all just look the same.
attached is a very simplistic example of what I'm trying to say. Hope the explanation makes some sense and helps.