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 display a range in the chart. I have attached what I have so far in Excel but no luck yet :-(
Any help is appreciated
This is what I made in GraphPad
than you all Patrick2788 PeterBartholomew1 m_tarler appreciate the help 🙏
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)
So you can use a 'stacked chart' to do this but you will need to add a helper column for the difference:
after i created the stacked chart I changed the formatting of the 'min' series to be no outline, no fill to give the floating look. as for the diff, I originally created the chart using min and max and then clicked on the max series and just shifted the range over to the diff column.
