Forum Discussion
Box and Whisker Problem
Hi everyone, Please can someone help or show me how I can make a similar chart in Excel as in the screenshot (this was in Graphpad Prism). Does anyone know how to layout the data? I only need to dis...
I agree with Matt. A stacked bar (a Gantt in this situation) is going to get you close the desired chart.
A little more playing with Patrick2788 's solution to reverse the order of the the categories and to redefine the maximum of each bar to allow for the offset created by the minimum series
Sheet1!max
=Table1[Maximum] - Table1[Minimum]
Chart Series
=SERIES(Sheet1!$E$2,Sheet1!exercise,Sheet1!max,2)